report like spreadsheet

[shank]

How do I make this table of data:

MerchName......VendorSku......UPC.............Price
Merch1............vSku1............UPC1............Merch1Price
Merch1............vSku2............UPC2............Merch1Price
Merch1............vSku3............UPC3............Merch1Price
Merch1............vSku4............UPC4............Merch1Price
Merch1............vSku5............UPC5............Merch1Price

Merch2............vSku1............UPC1............Merch2Price
Merch2............vSku2............UPC2............Merch2Price
Merch2............vSku3............UPC3............Merch2Price
Merch2............vSku4............UPC4............Merch2Price
Merch2............vSku5............UPC5............Merch2Price

Merch3............vSku1............UPC1............Merch3Price
Merch3............vSku2............UPC2............Merch3Price
Merch3............vSku3............UPC3............Merch3Price
Merch3............vSku4............UPC4............Merch3Price
Merch3............vSku5............UPC5............Merch3Price

Merch4............vSku1............UPC1............Merch4Price
Merch4............vSku2............UPC2............Merch4Price
Merch4............vSku3............UPC3............Merch4Price
Merch4............vSku4............UPC4............Merch4Price
Merch4............vSku5............UPC5............Merch4Price


Into a report that shows like a spreadsheet...

VendorSku...UPC........Merch1............Merch2............Merch3.............Merch4
vSku1.........UPC1......Merch1Price......Merch2Price......Merch3Price......Merch4Price
vSku2.........UPC2......Merch1Price......Merch2Price......Merch3Price......Merch4Price
vSku3.........UPC3......Merch1Price......Merch2Price......Merch3Price......Merch4Price
vSku4.........UPC4......Merch1Price......Merch2Price......Merch3Price......Merch4Price
vSku5.........UPC5......Merch1Price......Merch2Price......Merch3Price......Merch4Price

thanks

 

[Jeff Boyce]

Have you looked into crosstab queries and reports?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[shank]

I can get [VendorSku], [MerchName] and [Price] with no problem. But how do I
get the peripheral data incorporated into the cross-tab query like: [UPC],
[Descrip] and a few others I have. I get one of two below errors. I'm
thinking this can't be done and I need to setup a temp table and append data
into it. Thoughts?

You can't specify Group By, Expresison, or Where in the Total row for this
column.
Specify as sum or count...

or

To create a crosstab query, you must specify one or more Row Headings, one
Column Heading option and one Value option.

--------------------------------------------------------------------

 

[John]

Press F1 while in Access, read about Crosstab Query

 

[Duane Hookom]

I would create a main report that displays only unique VendorSku and UPC
values. Then create a multi-column subreport for the merchants and their
prices. Set the link master/child properties to the VendorSku and UPC (or
whatever).