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
Have you looked into crosstab queries and reports? Regards Jeff Boyce Microsoft Office/Access MVP "shank" wrote in message news:uwx5osVKJHA.3812@TK2MSFTNGP04.phx.gbl... > 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 > >
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. -------------------------------------------------------------------- "Jeff Boyce" wrote in message news:OG%23g0AWKJHA.1156@TK2MSFTNGP05.phx.gbl... > Have you looked into crosstab queries and reports? > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > "shank" wrote in message > news:uwx5osVKJHA.3812@TK2MSFTNGP04.phx.gbl... >> 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 >> >> > >
Press F1 while in Access, read about Crosstab Query On Wed, 8 Oct 2008, "shank" wrote: >How do I make this table of data: >Into a report that shows like a spreadsheet...
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). -- Duane Hookom Microsoft Access MVP "shank" wrote: > 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 > > >
