Columns in a report

[NEWER USER]

I want to build a Catalog report based on data selection(s) from several
multi list boxes. I am able to build the WHERE string for the query, but
struggle on how to get the data into different columns. I am selecting
Year/Make/Model/Product Group in the separate multi list boxes. I want the
report to display separate columns for each Product Group selected and fill
in the Part Number based on the other criteraia selected. Example; last 3 are
Product Groups (Oil, Air, Fuel); Part Number and Product Group data is stored
in two separate fields.

Year Make Model Oil Air Fuel
1999 Honda Accord A123 B435 C667

Any help on How to layout report appreciated.

 

[Duane Hookom]

There is a dynamic crosstab report solution at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=11.