Grubsy4u
Newbie
7 Posts October 5th, 2007
11:31 AM
#1
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
--------------------------------------------------------------------------------
Reply
Scott Price
Moderator
922 Posts October 5th, 2007
02:00 PM
#2
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
--------------------------------------------------------------------------------
Report Reply
Grubsy4u
Newbie
7 Posts November 8th, 2007
04:46 PM
#3
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??