How do I sum records that fall within a specific date range in a .

  • Thread starter Thread starter Guest
  • Start date Start date
How do I sum records that fall within a specific date range in a report
Click to expand...

And what determines the specific date range?
In the Report Footer:

=Sum(IIf([DateField] Between #1/1/2005# and
#6/30/2005#,[NumberField],0)

will sum your Number field for the 6 month period.
 

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

I would like to only sum the fields which equal a criteria that fall within a certian date. 4
Due Dates That Fall on Weekend 2
Count within a specific range 9
count items in a column that fall within a range in a report 1
Conditional Sum based on Date Range 1
Counting and summing in reports 2
Totalling records in a date range 1
IIf - Sum Problem 1

Back
Top