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??
1 1570 Rabbit 12,516
Recognized Expert Moderator MVP
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.
Sign in to post your reply or Sign up for a free account.
Similar topics |
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, Classmates, every dating site
out there, etc.).
Often there will be queries with multiple joins and sometimes may include a
few fulltext searches. Each page of results will have a limited number of
results displayed (obviously). As I understand it,...
|
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 search box i want to use is located on my website at
http://www.freemobileupgrades.co.uk/110s249/Google%20Search%20Page.html
|
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 hats.title OR
hats.description
LIKE '%s'",
$_POST);
|
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, *, 'FormsOf(INFLECTIONAL, tax')
WHERE = a.listing_id
ORDER BY RANK DESC, name
When I hard code the value 'tax' into the query, it returns over 500 results. But when I try and do it with a variable, it treats it as null:
|
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 page.
So if I enter the word "watches" into a textbox, the google search results would be displayed in an <iframe> in the results.htm page for the word "watches" with something like http://www.google.com/search?q= for "textValue".
I have did set...
| |
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 WHERE Company_Name LIKE \"%$postrimmedcompname%\" ORDER BY Company_Name" ;
This works fine. If I enter "estate agents", I get the results. and also if I enter "estate" or I enter "agents" I also get the results.
However, if I enter "estate...
|
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 wrong. I've also tried, Where Closed = 'N'
SELECT *
FROM my Table
WHERE Closed != 'Y' And Actionee LIKE '%colname%' OR Responsible_Org LIKE '%colname1%' OR Source Like '%colname2%' OR id LIKE '%colname5%'
ORDER BY id ASC
Any direction would be...
|
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 in this situation??
|
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 which
calculates the degrees, but using this in the search query slows the
execution and takes about 10 secs to complete which is unacceptable.
Please advice. Your help is much appreciated
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |