detail totals in a query

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

I have a table that records an attendance code (a, b, n,
t,m) Each code has a meaning. At the end of the day we
have to know the total ABSENT (CODEs a, b, n, m), TARTY
(code T) AND PRESENT (blank or null). I am trying to
develop a query to calculate the a detail report of the
ABSENT, TARTY, or PRESENT and the totals. PLUS, This will
role into a HISTORY db with the same request over selected
periods of time.

I envision a query record with the attend. code and a
value for absent, tarty, and present. I have not had any
luck in developing such a query. We would appreciate any
ideas or suggestions. Thanks
 
Charlie,

Create a query that Totals(the weird looking icon that
looks like the letter "E" when you're in design view.

Add your table, then have 2 fields:

Put this as the First FIELD with the Totals row as GROUP BY
Codes: IIf(
Code: 
="a" Or [code]="b" Or [code]="m" Or
[code]="n","Absent",[code])

Then put Code as the second field and select COUNT for the
Totals row.

You'll get totals by "Absent", "T", and Blank.
 
Back
Top