Count from two criteria

  • Thread starter Thread starter TY
  • Start date Start date
T

TY

On the same report, in one text box I need to count the
number of records where [Field1]>3600 and are within a
date range. In another text box count all the records
within the same date range.

I started with two queries, but I cant link them on the
same report.

Please help. Thanks.
 
Assuming you want this in the Report Footer:
first value
=Sum( Abs(Field1>3600 AND DateField Between #1/1/2004# and #1/10/2004#))
second value
=Sum( DateField Between #1/1/2004# and #1/10/2004#))
 
Back
Top