How do I count records, but not each comment under that record?

[Guest]

How do I count records in a report that have multiple items per record? The
report contains 100 records, each of which may have several entries per
record. My report shows a record (Liquid Number), and immediately below it,
the entries associated with that record (comment A. 5/3/2005, comment B,
6/15/2005, etc).

Access is counting all rows, but I only want to know the count of the Liquid
Number. Any help?

Liquid # Date Recd Comment
12345 6-1-2005 PM'd 5/25/2005
PM'd 5/27/2005

12346 6-2-2005 PM'd 5/29/2005
PM'd 5/29/2005

In the above example, I would like the report's record count to show
quantity 2 records, but Access displays quantity 4.

Thank you,
Greg H.

 

[David Lloyd]

One alternative is to use the DCount function to return the exact count that
you require. The function is documented in Access help.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


How do I count records in a report that have multiple items per record? The
report contains 100 records, each of which may have several entries per
record. My report shows a record (Liquid Number), and immediately below it,
the entries associated with that record (comment A. 5/3/2005, comment B,
6/15/2005, etc).

Access is counting all rows, but I only want to know the count of the Liquid
Number. Any help?

Liquid # Date Recd Comment
12345 6-1-2005 PM'd 5/25/2005
PM'd 5/27/2005

12346 6-2-2005 PM'd 5/29/2005
PM'd 5/29/2005

In the above example, I would like the report's record count to show
quantity 2 records, but Access displays quantity 4.

Thank you,
Greg H.