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
 
Iram,
A simple method is to add a calculated field to your query. Using the query design
grid... add a cloumn...
IsComplete : IIF( Not IsNull(CompleteDate, 1, 0)
Place IsComplete (hidden) on your report and Sum that value.
Identify and Sum your text values the same way.
 
Back
Top