473,405 Members | 2,310 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

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
1 1553
Rabbit
12,516 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

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

Similar topics

1
by: SC | last post by:
I'm developing a site that may eventually have a very large database of users (hopefully, but who knows). It will be a community website where users can search each other (think Friendster,...
2
by: turbosatan | last post by:
i need to send a query from a web app to a search page on my site i understand that to use googles search i would use something along the lines of http://www.google.com/search?=q but the...
7
by: Frankie | last post by:
I'm trying to run the following search query: $query = sprintf ("SELECT itemNumber, thumbnailURL, title, description, price FROM apparel,hats WHERE apparel.title OR apparel.description OR...
0
by: Casey | last post by:
I am really having trouble with a full-text search query. Here's what I've got: SELECT listing_id, RANK, name, address, city, zip, heading, phone FROM listings a, FREETEXTTABLE(listings, *,...
1
by: vHTML | last post by:
hello everyone :) I am trying to make a page which would take a "entered" on search query from the previous page and display results in google with that query in an <iframe> in the results.htm...
2
by: rob21century | last post by:
Hello i will be a web designer one day but until then i need a little help I have a search query that searches the database for user entered string. See below: $query = "SELECT * From MyTable...
2
by: fusonts | last post by:
Can someon show me how to wirte a mySQL search query to search from only the open records. This is what I have but it continues to return records that are closed so I'm obviously doing something...
4
by: Grubsy4u | last post by:
Does anyone know how i can do calculations for search query reports. How is this overcome because the search will be differrent with a different report every time. Is there a formular i can use...
6
by: paankhate | last post by:
Hi, I have a task at hand to reduce the time taken for search query to execute. The query fetches records which will have to sorted by degrees away from the logged in user. I have a function...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.