View Single Post
  #2  
Old January 29th, 2010, 02:17 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default Count distinct lines in a report

Are the work order numbers all printing together in the report in one location
or are they scattered around the report?

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Dominic wrote:
Hi all

I have a simple Access report that lists work order numbers, along with
various information against this order number. An individual order number
may appear more than once in this report.

I would like at thge bopttom of the report, the number of different work
order numbers in the report. I am trying to build an expression / formula to
do this, but am struggling a bit.

Thanks for any help anyone can throw my way.

DominicB