Please help. I am trying to count something in a Group Footer using a Text Box. If what I am doing is not doable, or there is a better way to structure this please tell me. Here is the situation:
This is an attendance report for Summer School ( Students may be enrolled in both a AM session or a PM session and could be absent in one or both.)
I have a report that is Grouped first by Student ID, then by date, in the detail section, I have two text boxes, one is AM Absences and one is PM Absences. Within these boxes can be the values E for (Excused), T for (Tardy), U for (Unexcused) and M for (Medical).
In the Student ID Footer, they would like to see total Excused AM Absences, Total Excused PM Absences, Total Unexcused AM Absences, Total Unexcused PM Absences, ect...........
I was trying to use a text box to basically say if the code was E then Count it in this box. If the code was T, count it in this box, etc.......
3 1767 MMcCarthy 14,534
Recognized Expert Moderator MVP
Try this for total Excused AM Absences and if it works then just follow the same rule for the others. -
=Sum(IIf([AM Absences]="E",1,0))
Mary
It works perfect! You are a genius!! Thanks.
MMcCarthy 14,534
Recognized Expert Moderator MVP
It works perfect! You are a genius!! Thanks.
No problem. Glad it worked for you.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Simon Matthews |
last post by:
Hope someone can help an Access beginner!
I've just started keeping my surgical logbook on access and it's a
simple flat-file affair. I have created several queries that will
list cases performed at different hospitals and reports based on the
queries to print out the relavent details.
What I would like to do is have a summary sheet in the Report Footer
section that lists a grid of each type of procedure performed as well
as the...
|
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: Megan |
last post by:
hi everybody-
i'm having a counting problem i hope you guys and gals could give me
some help with. i have a query that retrieves a bevy of information
from several different tables.
first let me give you a little background. this database is kind of
like a human resources database. it collects info about people, where
they work, and if they have any work-related issues where they work.
|
by: mjobrien |
last post by:
i am having the hardest time trying to get an unduplicated count of
student IDs from my report.
i have the following report
Student ID Term Hours
1111111 SU04 1.0
1111111 FA04 4.0
2222222 SU04 5.0
3333333 SU04 3.0
3333333 FA04 6.0
|
by: mjobrien |
last post by:
Thanks for the hint Allen (see below). But I am already doing that
count as total records read (5)in the report footer. That count is
unduplicated for the record not for the field - student ID as I've
indicated in my sample report. I really need an unduplicated count of
the student ID only. I guess my subject was not clear.
------------------------------------------------------------------------------
From: Allen Browne...
| |
by: pemigh |
last post by:
I have a report with pages breaking in the middle of text box controls.
And it's not just on a line-by-line basis, but sometimes (in a
situation that I can no longer recreate) just the bottom portions of a
line's letters were showing up at the top of a page.
My experiments show that Access will ordinarily break before a text box
if the whole thing won't fit, but I haven't been able to find a
property that will control this behavior.
I...
|
by: ChadDiesel |
last post by:
I appreciate the help on this group. I know I've posted a lot here the last
couple of weeks, but I was thrown into a database project at my work with
very little Access experience. No other employee knows anything about
Access. I've searched Google Groups, and that has been a lot of help, but
there are some questions that I just can't find the answer to. I'll try to
take it easy on the group after this question.
I have one more...
|
by: BJ |
last post by:
Can anyone tell me how to include a count of group records in a group
footer. I know (I think I know!) that I have to include an unbound text box
in the footer, but what expressions do I use to count the entries within a
group (subtotals I suppose).
eg: the column (group) headings are something like this:
Area Surname
London Smith
Giles
|
by: elgoober |
last post by:
Hi
I have a report that looks at no of products sold by customer by range.
The report groups on the range and I'm interested in counting the number of companies buying the range. Since they are grouped at query level I can rest assured that duplicates will not be included.
I've tried adding a dumb text box () and then adding a textbox on the group footer referencing () but that does'nt play ball.
BigSeries
is the group
|
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: 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: 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: 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: 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...
| |