Arranging data from a One-to-Many table.

[Hips]

I need some assistance. I have a master table (lets say
Warehouse) which has a subtable that will have up to 16
Radios located at that Warehouse. So far this subtable
is "vertical" with the first column being the Warehouse,
then 2 columns with the Radio's particulars (Model,
Status). I have to export this to an Excel sheet, but
the format needed is more "horizantal", whereas I need to
group it so I have the first column being the warehouse,
followed by 32 columns (2 columns per radio). Each row
will be each Warehouse location. There can be from 0 to
16 radios. I have experimented with the queries but
can't seem to find a solution.

Thanks,

 

[Van T. Dinh]

Try the NormalizeDenormalize sample from RogersAccessLibrary:

http://www.rogersaccesslibrary.com/TableOfContents.asp