Hey everybody,
I'm sure this is cake, but I'm still kinda stumped. I'm trying to summarize info on a report based on the number of entries on the report.
I have 5 fields: FName, LName, Program, SkillLevel, and PhoneNumber. Each of these fields make up one line of info on the report. I want to count the number of entries and summarize it at the end of the report. Do I have to have some kind of number field, maybe a hidden one, associated with the other details in order to count this?
Am I way off track? Like I said, this is probably simple, but Tuesdays are always my Mondays...
Thanks,
the beacon
3 1722 NeoPa 32,556
Expert Mod 16PB
Any TextBox in any report header section can have a formula
where [Item] is a control from your detail section. Any aggregate function (Count; First; Last; etc) can be used in the place of Sum().
Thanks for the help. I actually thought I tried that, but I was probably entering it incorrectly. Me and my hastiness.
Anyway, thanks again. My report is complete...bwoohahahahaha!!
NeoPa 32,556
Expert Mod 16PB
No problems. Glad you got it sorted :)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Bruce Rusk |
last post by:
I'm using Stephen Lebans' RTF2 control in a report, and have discovered what
may be a slight bug in it.
I have a lot of non-Western language (Chinese) text in my RTF field, and
such records get...
|
by: CSDunn |
last post by:
Hello,
I have a situation with MS Access 2000 in which I need to display report
data in spreadsheet orientation (much like a datasheet view for a form). If
you think of the report in terms of what...
|
by: Jessica |
last post by:
I have a database where a person is able to enter the different tasks
they do each day by specific department and matter.
On a form they enter the date, their name, and their title; in a
subform...
|
by: JaredEmery |
last post by:
Hello all,
It's my first database, and I have a query that shows me the quantity,
material, length, width and thicknesses of parts, and I'm using these
figures to do some arithmetic on a report...
|
by: BigNasty |
last post by:
I have created a report, where there is multiple items with different
values in a group that i total up at the end:
App 3
App 3
App 2
Com 1
Com 2
|
by: John Smith |
last post by:
I have two text fields in a table. One is Height, one is width. Some
examples of what might be each field:
Height Width
35' 35'
8' 6'
4 to 6...
|
by: MLH |
last post by:
If 3 things can be in one of 2 states,
the number of possible combinations
is equal to 2^3.
But if I have 3 things, 2 of which can
be in 2 states and the other in 3 states,
what's the simplest...
|
by: teneesh |
last post by:
I'm trying to create two reports that produce the same data. One is a summary report, the other is detail. The detail report, for example should display all the recrods below, but combined. For...
|
by: DanicaDear |
last post by:
I have a query HOTSTICK_ORDER_DETAILS which calculates how many hotsticks a customer must pay for. The name of the field is QTY_CHARGED. (It is calculated by knowing how many sticks they order, how...
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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,...
|
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...
|
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...
|
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...
|
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...
|
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,...
| |