MS Access vertical to horizontal data

Asked Dec 13 '21 at 19:54

Active Dec 13 '21 at 20:09

Viewed 18 times

I have data in an MS Access query that looks like this.

GroupID	GroupName	RateID
307819	AL0007	32282
307817	AL0007	32284
307816	AL0007	32280

I need to put it in a table that looks like this.

GroupName	RateID2	RateID3	RateID4
AL0007	32282	32284	32280

I have not been able to figure out how to write the correct query to populate the table correctly. I am hoping that someone can shove me in the right direction.

Any assistance would be greatly appreciated.

edited Dec 13 '21 at 20:09

asked Dec 13 '21 at 19:54

Michele Gaw

Calculate a group sequential row number in a query then use that query as source for a CROSSTAB with the calculated field as ColumnHeader. Review https://stackoverflow.com/questions/64565228/ms-access-restart-number-sequence and https://stackoverflow.com/questions/70052620/access-query-counter-per-group – June7 Dec 13 '21 at 20:35

MS Access vertical to horizontal data

0 Answers0