Count HELP!!!

[sysop470]

I am newbie and i need some help, i need to create a report, in which i have a field BATCH NO. I have some batch no with same numbers. I want to count the batches, but those that are duplicate it must be counted as 1.

Any help pls??

Thanks

 

[wazz]

in your first query group the rows.
in a second query count the rows of your first query.
?

 

[jerrywheels]

don't understand

Hello
i have the same problem, but just want an expression in a text box field on the report that counts the records on that report, but counts records with the same value in a field "RdsNoRec" as 1 record. Do i need a query and if so i don't understand what you sent.
Thanks

 

[jerrywheels]

Have you solved your problem? if not contact me, i have.