If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Columns in a report
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. |
#2
|
|||
|
|||
Columns in a report
There is a dynamic crosstab report solution at
http://www.rogersaccesslibrary.com/f...sts.asp?TID=11. -- Duane Hookom Microsoft Access MVP "NEWER USER" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|