Help with Totals from two fields

[phazzard]

Simple access table that shows orders placed by a single rep or team of reps. Here is example of data in access table:

	Rep1	Rep2	Rep3	Sales	Per
1	John Wilkins	Tom Reynolds		1	$5.00
2	Tom Reynolds			8	$2.00
3	Adam Toms	John Wilkins	Bill Booth	1	$4.00
4	Bill Booth			0	$0.00
5	Bill Booth	Adam Toms		2	$1.00

I would like to have a query that can look at name in Rep1, Rep2 and Rep3 field for totals

I would like to see query results as such:

		Sales	Total	Unique	Available
	Adam Toms	3	$6.00	2	2
	Bill Booth	3	$6.00	2	3
	John Wilkins	2	$9.00	2	2
	Tom Reynolds	9	$21.00	2	2
	TOTALS	12	$27.00	4	5

Sales = QTY of sales the rep was a part of
Total = Sum sale * Per
Unique = Unique records with sales of 1+
Available = Unique records with 0+

Hope this makes sense - My struggle is getting it to pull from the second and third rep fields to be included in the data.

Any help is appreciated

Phil...

[ranman256]

Make a report table,
run 3 append queries,1 for each Salesman to append the Qty,amt,etc.
report off this.