get query to show all colums 1

[Greg553]

I am trying to get my query to show all results for each lift type for each player and weight.
This is new territory for me and not sure how to go about it.

this is my set up

TBL_corelifts
Lift_ID ( each lift has its own ID)
LiftType (bench press, squat,dead lift etc )

TBL_WeightResults
Weight_ID_auto field
Player_ID
Lift_ID
WeightLIfted

Lift_ID ties into lift type

What I'm trying to get is a column for each lift and weight lifted for that lift. The example below is how i would like it to look in the final query and report.

Player Name Bench Press Squat Dead LIft
Joe 235 300 350
blake 275 356 400

thansk for all previous help

 

[PHV]

Use a crosstab query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Greg553]

Thanks PHV, worked liked a charm.
I have never used one of those before.
Went into the wizard and set it up....

Thanks again greg