Grouping

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I need some simple grouping help. I have a select query with a column 1
that has Earnings Codes of 01, 02, 03, 04. Column 2 is an amount that
corresponds to the earnings code in column 1. (These codes are grouped by
check number.)

How can I show on a report, by check, a sum of earn code 01. Also separately
a sum of earn codes 02 and 03 and 04.

01 would be regular wages. 02, 03 and 04 would be misc other wages that show
up Other Wages. Thanks.
 
Hi Rob,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

Create a query that uses the Totals functionality. Set CheckNumber in the
first column and the Total line to GroupBy. Place the EarningsCode in the
second column and set it also to GroupBy. Place what ever column has the $
values in the third column and set the Totals line to Sum. You should then
one line for each CheckNumber/EarningsCode with a summed amount.

Create your report and in Sorting\Grouping group first by check number
(with a group header) and then by EarningsCode. Place the CheckNumber
field in the group header, and then place the EarningsCode and SumOf$
fields in the detail section. You will get one line for each check(in
order) and under that one line with $Sum for each of the EarningsCodes.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top