AutoSum Text and Date Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.
I am using Access 2000 and I have a report that pulls about 10 Date and Text
fields from a table.
I need to autosum or have a count at the bottom of the page with totals i.e.
there may be 100 records total but 15 of those records may have a "Complete
Date" so I want to count the 15 using an autosum, and the same with a few
Text fields.
How can I do this?

Thanks.
Iram/mcp
 
I can give you an example on how to create a sum on such a field

create a text field in the report, in the detail section where the text
field located in, in the control source of this field write
=IIf([TableFieldName]=""Complete Date",1,0)
Set the properties of the text field
Visible = No
Running Sum = Yes

On the Page footer create a text field and write
=[The text field name created above]

I hope that make sense.
 
Back
Top