Count with no queries 1

[Tejanorey]

Is there a way to count records on a report without having any querys established. The database that I have has its all of its reports 'feeding' of the table (no queries created). Tejanorey

"Do not attack the First Marine Division. Leave the yellowlegs alone. Strike the American Army."
- Orders given to Communist troops in the Korean War; shortly afterward, the Marines were ordered to not wear their khaki leggings to keep the enemy from immediately fleeing

 

[randysmid]

Hi,
You can use the DCount function to return record counts from a database, all without having to create a query.
Here is a sample, given that the table name is tblExample:

This code should be placed in the Control Source for a new text box added to the report.
=DCount("[fldExample]", "tblExample&quot

If you want to count all the records for a specific customer, you would set up the function as follows:
=DCount("[Customer_id]", "tblOrders", "[Customer_id] = '1234'&quot 'this presumes that Customer_id is string HTH,
Randy Smith
California Teachers Association