How to Group and Count Unique Records

[MRZ via AccessMonster.com]

Hello!

Background of project:

I have a table with SS#, Student Name, and other related information.
This is a consolidated list from a total of 10 lists during a week of
registration.
Basically we need to figure out what student register and paid 100% and what
student still owns money during these 10 days.

Each list had a unique indetifier (List#) so I know where the information
comes from.
Therefore my table looks like this:

List# SS# Name Amount
Percent Remaing
1 123456789 John Doe 1,000 100%

2 123456789 John Doe 500
50%
3 123456789 John Doe 250
25%


Right know my table is sorted by SS# so I automatically see the following
grous:

single
double
triples
quadruples


I need to be able to run a query or report that only gives me the total of
single students, double student, etc.
Individually.

Thank you very much for any help
MRZ

 

[Céline Brien]

Hi MRZ,
If I understood you well, you need two query.
First a query to calculate amount still to pay.
Than a query grouping by student and adding OwnsMoney.
The result of the first query would be :
List# SS# Name Amount Percent
Remaing OwnsMoney (calculate field in the query)
1 123456789 John Doe 1,000
100% 0
2 123456789 John Doe 500
50% 500
3 123456789 John Doe 250
25% 750
The result of the second query would be :
SS# Name OwnsMoney
123456789 John Doe 1250
Is that what you need ?
If so I would be please to guide you in the creation of those queries.
Céline