I have a parameter query to filter by date from which I run a report. I
need to be able to count the number of times a particular product or
error type appears after the report is run from the query. The products
and error types are limited to a defined list. I need to put these
summary totals in the footer. Using the Dcount function works, but
returns all items, not those within the date range.
Any assistance would be appreciated.
Miguel
3  4306 
Miguel wrote: I have a parameter query to filter by date from which I run a report. I
need to be able to count the number of times a particular product or
error type appears after the report is run from the query. The products
and error types are limited to a defined list. I need to put these
summary totals in the footer. Using the Dcount function works, but
returns all items, not those within the date range.
Any assistance would be appreciated.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You can use a running sum control in the report and the IIf() function
to count specific products & "error types." E.g.:
Set up a TextBox in the Detail section (or whichever section you are
placing the product/error type data) w/ the Running Sum property set to
Over All. Then set the Control Source property to something like this:
=IIf([product]="ironing board",1,0)
Name this control something like txtIroningBoard Count. You can set it's
Visible property to No.
In the Report Footer put another TextBox with the Control Source set to:
=txtIroningBoar dCount
This TextBox will show the total count of all ironing boards in the
report. Label it something like "Ironing Boards: ".
Do the same for all other items you want to count.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRASiBIechKq OuFEgEQL75gCeNx 2NlKKONttzPhGEA rnxpqA7P4cAn0XQ
ijLTLVfF1J+YChC 6hibyUr12
=OpPX
-----END PGP SIGNATURE-----
Many thanks. I will try this out.
I followed your advice and it worked perfectly. Thank you.
Miguel
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Cro |
last post by:
Hello Access Developers,
I'd like to know if it is possible to perform a count in an expression
that defines a control source.
My report is based on a query. In my report, I want a text box to
display the number of times a certain value appears in a certain field
(i.e. perform a ‘count'). I will be doing this for many values in many
fields so do not wish to have scores of queries to build my report.
|
by: Terry E Dow |
last post by:
Howdy,
I am having trouble with the objectCategory=group member.Count attribute.
I get one of three counts, a number between 1-999, no member (does not
contain member property), or 0. Using LDIFDE as a comparison I get the same
results. No members means just that, an empty group. Zero means that the
DirectorySearcher.SizeLimit has been exceeded....
|
by: ZRexRider |
last post by:
Hi,
I have some relatively simple reports that pass parameters to SQL
Server stored procedure to retrieve data. These reports are set to
group the data by an individual's name and print their name along with
a count field. I would like to sort these reports by descending value
of the count field. (normally I would do all of this in the stored
procedure but the SP is designed to be "generic" - called from other
reports so I want...
|
by: AtCor |
last post by:
SELECT Sheet1$. AS , CASE Sheet1$. WHEN 'CSPP100A2344' THEN '0' END AS Extension, SUBSTRING(Sheet1$., 1, 4)
AS , SUBSTRING(Sheet1$., 5, 8) AS , SUBSTRING(Sheet1$., 1, 4)
+ '_' + SUBSTRING(Sheet1$., 5, 8) AS , Sheet1$. + '_' + SUBSTRING(Sheet1$., 1, 4)
+ '_' + SUBSTRING(Sheet1$., 5, 8) AS , Sheet1$. + Sheet1$.Surname AS ,
CASE Sheet1$.NOTES WHEN 'visit...
|
by: haresh.amis |
last post by:
hello to all,
I m using .net 2.0 and i face a problem that is as under
Well I have a checkboxlist which i bound in .cs page
now I want to count that how many checkboxes ate checked ( In
javascript ) and
checked checkboxes text will be concat and that string will be pass on
to report query
I m trying on by this code but it's not work
| | |
by: nospam |
last post by:
I have a report to count some statistics of case data. I can't figure
out how to make Access group and sum/count information to give me a
nice statistics report. Basically the database has case information
for matters at a law firm. The point is to create this report to
group on the attorney. Then for each attorney count the cases where
the status (CStatus is the field) is "Open", where the status is
"Closed", sum the size of the media...
|
by: misscrf |
last post by:
have a report that I am trying to build and I can't figure out how to make Access group and sum/count information to give me a nice statistics report. Basically the database has case information for matters at a law firm. The point is to create this report to group on the attorney. Then for each attorney count the cases where the status (CStatus is the field) is "Open", where the status is "Closed", sum the size of the media in all of the...
|
by: MLH |
last post by:
I put the following
Count() From tblPHPDeveloperDoItems Where = True
in a report footer. It's OK at compile time. But when the report
runs - it gives me an error. Is there something I can do differently
to count up the number of records in the report where
is True?
Thx.
|
by: tuxalot |
last post by:
I've copied the option group from my form, and pasted it into the report which seems to work fine. Now, I wish to total the option items in the report. So I have a query that grabs records within a given set of dates. So, the result on the report is a series of records, one line at a time, and the option group is placing option a,b,c,d,e in their respective places. So far so good. Now, I wish to sum these options individually. Count of...
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
