Date Ranges in Access 2000
How do I show multiple date ranges in Access 2000. I need to see counts of items that are 0 to 15 days old, 16 to 30 days old and so on, on my reports?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 7, 2008 7:31 PM
UPDATED:
August 8, 2008 1:52 PM
Answer Wiki:
If the items are stored as rows in a table with a date, you could do this in a query: Select Item, Sum(IIf(DateDiff("d",[ItemDate],Now()) Between 1 And 15,1,0)) AS 0to15, Sum(IIf(DateDiff("d",[ItemDate],Now()) Between 16 And 30,1,0)) AS 16to30...... From Table Group By Item.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
