Count from two criteria

[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.

 

[Duane Hookom]

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#))