467,188 Members | 1,436 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,188 developers. It's quick & easy.

Search Query Calculations (Un-answered question below) please help!

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??
Nov 20 '07 #1
  • viewed: 1285
Share:
1 Reply
Rabbit
Expert Mod 8TB
1- Tell me the total amount of people i had in the report
2- And the total number of cars within the report.

For the first question, you have to do a DCount on an unduplicated query of people.

For the second, you can just do that with an aggregation query.
Nov 20 '07 #2

Post your reply

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

Similar topics

1 post views Thread by SC | last post: by
7 posts views Thread by Frankie | last post: by
2 posts views Thread by rob21century | last post: by
6 posts views Thread by paankhate@googlemail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.