Using field as criteria for Query

P

PiB311

Hello all. Here's my problem.

I am creating some code to export data to Excel. The data currently is
available in Access and is viewable by Workgroup (showing data rolled up for
each individual in the group) and then individual records for each person
within that workgroup.

Using the my query for Workgroups, I want to run through all individuals and
use their name as criteria for a query to show all information for each
individual in that group.

some thing like this...

Bikes sold Avgsoldfor Profit
Bike 1 12 $150 $50
Bike 2 10 $120 $35
Bike 3 20 $80 $80


Then a seperate page for:

Bike 1
sale 1
sale2
sale3.....

Please let me know if additional information is required.

Thanks!
 
Top