Please help - SQL ? (I think) 
Author Message
 Please help - SQL ? (I think)

I have posted this before, but no response.  I have 3 databound grids, top
one you click on a Customer, the second grid shows a summary of orders for
that customer grouped by week.  What I need to do is have the Week column
show the first day of the week.  It currently shows the week of the year
number, i.e., week 20 of this year.  
Does anyone know how to do this?  Even if it an attached grid.  Even code
sample just to figure out what the first day of the week for a week number
would be GREAT.
Here's my current code (SQL statement):

QryDued$ = "SELECT PM_DUED.FCUSNAME As Customer," _
            & " Format(Sum(PM_DUED.FDUEQTY/PM_DUED.FMULTIPLE),'#,###.#0')
AS Panels," _
            & " Format([FDUEDATE],'ww')As Week FROM PM_DUED" _
            & " Where PM_DUED.FDUEDATE <> Null And PM_DUED.FDUEQTY <> 0" _
            & " And PM_DUED.FMULTIPLE<> 0 AND PM_DUED.FDUEDATE>DATE()" _
            & " And PM_DUED.FDUEDATE<=(DATE()+70)" _
            & " And FCUSNAME = " + Chr$(34) + Customer$ + Chr$(34) + "GROUP
BY" _
            & " Format([FDUEDATE],'ww'),PM_DUED.FCUSNAME"

I would REALLY appreciate any help anyone can give me, via email

Thank you,
Vince Strahan



Sat, 23 Oct 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP,

2. sql help, I think

3. Help me please - Max String length 2 Billion chars - I don't think so

4. help please My first post did'nt work( I think) - 2 Attachments [0/2]

5. help please My first post did'nt work( I think) - 2 Attachments [1/2]

6. File Sharing/security problem - I Think! - Help Please

7. please help..time stamp problem me thinks !

8. Thinking of Buying HELP ME Please.

9. Can anyone HELP me PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE

10. PLEASE HELP PLEASE HELP PLEASE HELP

11. SQL help problem. Please help

12. Thinking about WinHelp Tools? Think $$$

 

 
Powered by phpBB® Forum Software