Counting and displaying line items

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

Guest

Is there a way with access 2003 to count how many line items there are on a
report and show that number in the footer?

For example a query says it has 45 items, and I want that to show up in the
report footer.

Any help would be good. Thank you in advance
 
Put a textbox in the report footer and put the following expression in the
control source property of the textbox:
=DCount("*","NameOfQuery")
 
Using DLookup() would be a waste of resources. I would add a text box in the
Report Footer section with a control source of:
=Count(*)
DLookup() may not provide accurate results if you use a "Where" clause in
your DoCmd.OpenReport method.
 
Back
Top