Query bi-weekly

R

Randy

I have a data base for my personal budget and would like to group the entries
bi-weekly. I would also like them to appear on the same page of a report .
For instance, 1/1/2008 thru 1/15/2008 at the top of the report and 1/16/2008
tru 1/31/2008 at the bottom. I would also like to have seperate totals for
each group and a grand total at the bottom for the month. Does this make
sence? Does anyone have any ideas?
thanks
 
J

Jerry Whittle

Don't try this in the query. Rather gather up all the needed records in the
query then use the query as the basis for a report. In the report's sorting
and grouping options, you can group on the date field by Week and make the
interval 2.
 
Top