Report calculations

Hi All,

My name is Daniel, and i have been having problems trying to work out how to get count figures in a report that doesnt contain any numerical data. For example if i had a list of people names the cars they own- How would i get the report to

1- Tell me the total amount of people i had in the report
2- And the total number of cars within the report.

Any suggestion of methods would be greatly appreciated.

Many thanks all

Regards Daniel

re: Report calculations

The DCount() function will give you a count of records, regardless of their respective data types.

This is an example lifted directly from Access help files:

=DCount("[OrderID]", "Orders", "[ShipRegion] = 'CA'")

This will count all the OrderID's in a table named "Orders" where the table's ShipRegion field has the entry CA.

Regards,
Scott

re: Report calculations

Thanks Scott....

The report is now doing calculations.

But does anyone know how i can set it to do calculation for search query reports.

I can't use the formual as suggested because i the search will be differrent with a different report every time.

Is there a formular i can use in this situation??