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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query bi-weekly 1
Complex Record Selection 1
query to sort nos 2
Select data and sum by weeks in a month 3
Current bi-weekly total 2
query to sort data 3
What's Wrong With This Query? 6
show top values 5

Top