Is this possible?

[Laura]

I have a table with multiple duplicate entries for "employer" and need to
query only certain "types" if they exist. For example, from:

Employer A Active
Employer A Quoted
Employer B Rejected
Employer C Active
Employer C Rejected
Employer D Quoted

I would want to retrieve only one record for each employee and want to
specify which one. For Employer A I want only the "active" record, for
Employer B I want the "rejected" record since it is the only one available,
for Employer C I want the "active" record and for Employer D I want the
"quoted" record since it is again the only record available.

Thanks in advance for any help you can give to this newbie.

 

[Laura]

I think I may have figured it out actually using Total and Group By and
Min/Max for the type of employer. Thanks for the response!

Hi Laura,

How do you want to indicate the employer and type? You could use a parameter
query with two parameters. In you query, in the criteria box of the Employer
field, put [What employer?] and in the Types criteria box, put [What Type?]
and run it. I'm guessing at how you are approaching it but this is a quick
and dirty approach.

Bonnie
http://www.dataplus-svc.com

I have a table with multiple duplicate entries for "employer" and need to
query only certain "types" if they exist. For example, from:

Employer A Active
Employer A Quoted
Employer B Rejected
Employer C Active
Employer C Rejected
Employer D Quoted

I would want to retrieve only one record for each employee and want to
specify which one. For Employer A I want only the "active" record, for
Employer B I want the "rejected" record since it is the only one available,
for Employer C I want the "active" record and for Employer D I want the
"quoted" record since it is again the only record available.

Thanks in advance for any help you can give to this newbie.