Count/report problem (1 Viewer)

[UniqueTII]

This problem is making me feel like an idiot, so I'll turn here for help. Here's the scenario:
I have 3 tables and I need this info from them:
StudentInfo : [LastName],[FirstName]
EVF: [SSN],[StartDate],[EndDate],[JobTitle], [CWS Eligibility]
PClerkInfo: [Department]

Here's what it all adds up to:
Right now I can print a report of all students employed with College Work Study funding and all of their info listed above. The problem is that some students have more than one job, and I need to be able to make a report of just those students and the info on both of their jobs. I made a file duplicates query that finds all 34 students, but I cannot for the life of me figure out how to make the report of just those students.

 

[jfgambit]

Since you have a duplicate query, why not copy the report and change the source of it to the dulpicate query?

Is this what you are looking for?

 

[UniqueTII]

When I tried to add the other fields of the report to the duplicate query, I got problems with aggregate functions.

I ended up doing a convoluded (sp) macro that runs the duplicate query, creates a table, adds the student info, runs a couple other queries, and then makes the report. Whatever works, I guess. This is why I don't get paid the big bux.