472,789 Members | 1,376 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Report with totals only, no details


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,

Nov 13 '05 #1
3 1939
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,
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.


Nov 13 '05 #2
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!

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #3

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 ...


Nov 13 '05 #4

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...
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...
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...
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...
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...
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"...
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...
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...
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...
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...
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.