Query bi-weekly

  • Thread starter Thread starter Randy
  • Start date Start date
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
 
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
How do I get Totals of rows values in query? 1
Current bi-weekly total 2
SQL query urgent pls help 2
query to sort data 3

Back
Top