By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Report calculations

P: 16
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
Oct 5 '07 #1
Share this Question
Share on Google+
2 Replies

Scott Price
Expert 100+
P: 1,384
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.

Oct 5 '07 #2

P: 16
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??
Nov 8 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.