Min/Max question

[darude]

Hello,
I have a query result that looks like this:

StudentID EmplID
210739 3003
210739 E10534
210739 E15953

I want to further query this record to look like this:

StudentID Job1 Job2 Job3
210739 3003 E10534 E15953

I can get Job1 and Job2 using Min/Max but, I'm not sure how to get the third job. Thank you in advance.

 

[traingamer]

Maybe a cross-tab query will do the trick. Not sure we actually have enough information to help.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[dhookom]

darude,
You must be able to specify which EmplID values should be 1,2, or 3. Are these just sequenced by EmplID order?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[darude]

Thanks for responding. I simply want to roll them into one record. using min/max gets the first two records to roll into one record, but i'm not sure how to get the third record to roll up.

 

[lespaul]

have you checked out FAQ701-4233

this will return all your "child" records in a single field though:

StudentID Jobs
210739 3003,E10534,E15953



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi