Dates in Queries and reports

S

ScotStuart

Hi
I have a database with salesdate and sales assistant as fields. I have all
sales listed from January through now. Can anyone advise me how to "group"
the queries by Week? SHould there be some specific date format used? I would
like to be able to show Sales per day per assistant on a weekly basis and
possibly producing a report with all sales assistants sales for the week...
and hopefully a chart !! I have bought all sorts of books on this, but cant
make head nor tail of them... they dont pay much attention to grouping
issues. You guys are always great.

Thanks
Stuart
 
F

fredg

Hi
I have a database with salesdate and sales assistant as fields. I have all
sales listed from January through now. Can anyone advise me how to "group"
the queries by Week? SHould there be some specific date format used? I would
like to be able to show Sales per day per assistant on a weekly basis and
possibly producing a report with all sales assistants sales for the week...
and hopefully a chart !! I have bought all sorts of books on this, but cant
make head nor tail of them... they dont pay much attention to grouping
issues. You guys are always great.

Thanks
Stuart
Click to expand...

Add a new column to the query.
SalesPeriod:DatePart("ww",[DateField])

Group your report on SalesPeriod in the Report's Sorting and Grouping
dialog.

Look up DatePart() in VBA help for the additional arguments available
in this function.
 
Top