grouping days (1 Viewer)

[annedelina]

I am pulling information from a make table
query into a report. I am then using a wizard to create the report. I want to group dates by having all the dates in the same week. I also want the function to calculate all the values for the week. any suggesstions?
thanks
anne

 

[Lou]

Anne.
After you have created the data table, you are going to need a table which shows, date, week, period, quarter, year, etc (depending upon reporting requirements).

In a separate query, you are now able to group the info together based on fiscal week. I would suggest that you have the week, period and quarter numbers starting with "1999_". I suggest this because I have a feeling that you are going use the same file for next year. This way, you just have to append the dates for next year into your current date table. (I use this methodology for GL reporting purposes)

Bear in mind, that if you want to create the week number in your make table query, you can.

Hope this helps.
...Lou