=Abs(Sum... with Between [Forms]!... And [Forms]!...

[Stevehewitt]

Hi Guys,

I'm trying to get a field to add up how many records are in the details sections based on on the following:

=Abs(Sum([DateIn]=Between [Forms]![frmReportDateSpecific]![txtStartDate] And [Forms]![frmReportDateSpecific]![txtEndDate]))

I have a open form where two date ranges are entered in; if the DateIn field has data between these ranges I need this field on the report to add up how many records there are.

What am I doing wrong!?

Cheers,



Steve.

"They have the internet on computers now!" - Homer Simpson

 

[misscrf]

Im not great with this stuff, but I would put the criteria (between form fields) in the query/control source of the report. Then make the report field have the abs funtion on that field which pulls criteria separately.

try it out.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[randysmid]

Hi,
An alternative method is to use DCount. I wrote an FAQ on how to use DSum, and the technique is almost identical.
faq703-3066
HTH, Randy