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 a lot
 
K

KARL DEWEY

Use a query like this for report --
SELECT YourTable.COMPONENTA, Count(YourTable.COMPONENTB) AS
CountOfCOMPONENTB, Sum(YourTable.COMPONENTC) AS SumOfCOMPONENTC,
Format([YourDate],"yyyymm") AS YearMonth, IIf(Day([YourDate]) Between 1 And
15,1,2) AS PartOfMonth
FROM YourTable
GROUP BY YourTable.COMPONENTA, Format([YourDate],"yyyymm"),
IIf(Day([YourDate]) Between 1 And 15,1,2);

Use the report Sorting and Grouping to group on YearMonth and again on
PartOfMonth.
 
R

raskew via AccessMonster.com

How many times are you going to post this? By my count, this is your 3rd
rendition of the identical post.

Bob
 
Top