Reporting by Week Commencing

[Patonar]

Hi,

I have a database that lists customer orders. There is a field within
this customer order table that shows DeliveryDate - these could be
dates any day during the working week.

I need to be able to develop a report that Sums the total QTY ordered
by Week Commencing - how would i go about doing this?

Presumably i need somehow to calculate when the week commencing is in
my report - can this be done with the existing data that i have???

Regards,

Andy

[thunder1]

I think maybe you can do like this:
select * from your_table where weekday(date())=6 and
DeliveryDate<=date() and DeliveyDate>dateadd('d',-5,date()) order by
QTY;
Then in every Friday,you can get a report of this week.

Patonar 写�：

Hi,

I have a database that lists customer orders. There is a field within
this customer order table that shows DeliveryDate - these could be
dates any day during the working week.

I need to be able to develop a report that Sums the total QTY ordered
by Week Commencing - how would i go about doing this?

Presumably i need somehow to calculate when the week commencing is in
my report - can this be done with the existing data that i have???

Regards,

Andy

[Ron2006]

There is also a function called datepart

datepart("ww",nameofdatefield) will give you the weeknumber for the
supplied date.

get the weeknumber of any supplied date and then you can see if any
record has a delivery date with that same week number.

Ron