Hello,
I'm creating a one-page report that will display only total counts, no
details. I want to examine the values of 2 fields on the source table,
and add to appropriate counters accordingly. MattressSize can have 3
values, Condition can have 5 values. Therefore I have 15 unbound text
boxes in the report's Footer section which have counts of the
combinations of these 2 fields.
My question is: where do I put the logic to look at detail records
and examine field contents for each row? I set up a Detail_Format
event, where I have an IF statement to add to counts accordingly, but
this is not getting executed. I'm guessing that if I don't have details
being printed, I can't use the DetailFormat event.
I am relatively new to Access programming, so feel free to give any
suggestions on the best way to do this.
Thanks in advance,
Lori
3  2018 
Lori
there are several more elegant approches for this.
1. a Create first a crosstab query with one of the (fixed) dimensions
as a columnname
b one of the columns mut refer to a value to aggregate (sum, count,
etc)
c The resulting columnnames will be fixed after report-creation
from that table
2. think about making a pivot-table in a spreadsheet with mattress-size
and condition as dimensions. You could easily add more dimensions at
will (brand, branch-office etc.). Every dimension is derived from a
table-column as well as the values to summarize. If the table would be
too big for a spreadsheet it could be saved as a cube or it could be
already pre-summarized though totalling the values by SQL (the
sigma-button) and then used in a spreadsheet. A query can be accessed
from a spradsheet directly.
3 try using the pivot-table form wizard to creat a pivot-table in
Access (I don't have practical experience with it yet, but it should be
probably the easiest method.)
All three give a different type of output, but should be much morea
easy and/or flexible to create.
Marc
Hi Marc,
Thank you so much for your reply and your instructions. I followed
them, with my big Access book by my side, and created a Crosstab query
and got exactly what I wanted. I don't even think I need a pivot table
- checked it out in the book (and my users have Access 2000, so I'm not
sure if they even have this capability). Anyway, I'm fine with the
results of the Crosstab.
Just one thing, though - what do I do about the column headed "<>"? (is
this giving me the counts of non-null values?).
Thanks so much! You saved me today!
Lori
*** Sent via Developersdex http://www.developersdex.com ***
Lori,
Do you use a Access-version > 2000 ?
I don't know for sure what that column means, but I could imagine a
column for all values for the column-dimension that are not mentioned
(<> or unequal to ..) in the column-names generated by the query. The
column-names in a report are static and not derived from data-values in
the table. The column-names can change when the crosstab-query contains
new values, but the report doesn't change it's layout accordingly. I
suppose the wizard created that column in the report to count for
values not mentioned in the column-names. I don't use this feature
myself, so may be you could learn me more about it ...
Marc
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: John Baker |
last post by:
Hi:
I have a situation where I have a series of time records (one or more per day) for a
number of projects. Each record has an identification for the activity conducted during
the period recorded. For any project, the activity may be one of many things, and the
activities may vary by project number.
I need to run a report and end up with a list of all the times reported, and totals by the
project number and the activity, as well as...
|
by: David B |
last post by:
I have a report with 2 sub reports on it.
The report is an invoice and the sub reports are dropping data onto the invoice.
This worked fine if generating 1 invoice at a time.
I am trying to create a run of invoices. I would like the appropriate data for
each custid from each sub report to be on the same page. The nearest I can get
is 2 pages for each customer
Any Thoughts
TIA
David B
Hexham UK
|
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to Create a Dynamic Crosstab Report
PRODUCT :Microsoft Access
PROD/VER:1.00 1.10
OPER/SYS:WINDOWS
|
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have reports at the plan (overall totals), department and division
levels which have sorting and grouping implemented with this new
|
by: Amac |
last post by:
I would like to create a summary report based on a "Type" field in my
table. I would like to create the following report:
Type 1 Total Balance Type 4 Total
Balance
Type 2 Total Balance Type 5 Total
Balance
Type 3 Total Balance Type 6 Total
Balance
----------------------------------------------------------------------------
| | |
by: sara |
last post by:
Hi -
I have looked at all posts and tried both Allen Browne's Report
Sorting at run Time
( Select Case Forms!frmChooseSort!grpSort
Case 1 'Name
Me.GroupLevel(0).ControlSource = "LastName"
Me.GroupLevel(1).ControlSource = "FirstName") .....
And another post that was OrderByOn = True and setting the sort Order.
|
by: lorirobn |
last post by:
Hi,
I have a report displaying items that are missing from a room. I
created 2 queries, the first getting the items IN the room, and the
second being an "unmatched" query that references the first query
where Item is Null. I use a subreport for the details, and the
results display correctly.
However, the Report_Details event of the subreport is executed about 2
or 3 times more than I would expect (I think 3 times when I have a
|
by: prn |
last post by:
Hi folks,
I'm looking for a little advice here. I need to create a report that is totals only, with no detail records. I have a database with a lot of individuals (people) and the report has to have some overall totals, totals per state, totals by gender, race/ethnicity, and several other criteria. This report does not need to (and should not) report on each individual, just the totals.
I can create expressions for each of the items I...
|
by: ollyb303 |
last post by:
Hi,
I am trying to create a dynamic crosstab report which will display number of calls handled (I work for a call centre) per day grouped by supervisor.
I have one crosstab query (Query1) which has the following fields:
SPID (supervisor ID), total:group by, as row heading
Date, total:group by, as column heading
Calls handled, total:sum, as value
Date, total:where, criteria between and - this is taken from a form,
|
by: peter1234 |
last post by:
I am trying to produce study notes for ACCESS, and for many days I am stuck trying to produce totals and subtotals for table ‘Order Details’ from ‘Northwind Sample Access Database’. The fact that I am working in two locations and using two versions of ACCESS has made it clear that there is no webpage that lists clearly, step by step, the procedure, by ACCESS version.
In ACCESS 2000 I have unsuccessfully applied the code in...
|
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: 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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
