Query that returns priority levels in separate columns

[Steve23147]

Hello all,

Thank you for assisting me.



I have a query that returns an individual's priority levels for an object. How can I get the query to returns the results in separate columns.

Sorry for being so vague. This is a work query and I can't release much more information than that.

Maybe this can help explain what I need a little better.


What I am getting:

Joe 1 Apple
Joe 2 Banana
Joe 3 Orange


What I want:

Joe Apple Banana Orange



Thank you for your help!

[rpeare]

That's called a crosstab query

Joe Would be your ROW SOURCE
Fruit would be your COLUMN HEADER
and the quantity would be your VALUE (sum probably)

[Steve23147]

Thanks! That worked!

I figured it was something super simple that I was just overlooking.