Can My Report Look Like this?

Hi,
I have a table in access that contains product numbers, prices and these
prices are based on location. This information is all going down, but what I
would like to do is to create a report showing each product going down but
showing prices going across depending on the location. Below is an example of
what I’m trying to achieve so if anyone is able to help me I would really
appreciate it.

**EXAMPLE **
Product # Description EastCoast Midwest South
West
123545 Ford Escape 15,000 14,000 12,000
16,000
13254 Ford Fusion 27,000 25,000 24,000
28,000

You should be able to create a Crosstab Query that arranges the data like
that, and use that Crosstab Query as the basis for a report.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Santi" wrote in message
...
Hi,
I have a table in access that contains product numbers, prices and these
prices are based on location. This information is all going down, but what
I
would like to do is to create a report showing each product going down but
showing prices going across depending on the location. Below is an example
of
what I'm trying to achieve so if anyone is able to help me I would really
appreciate it.

**EXAMPLE **
Product # Description EastCoast Midwest South
West
123545 Ford Escape 15,000 14,000 12,000
16,000
13254 Ford Fusion 27,000 25,000 24,000
28,000

Douglas,

Thank you for the information, but I have little experience with the
Crosstab Query. What steps do I need to take to make this happen? I tried
doing this on my own but Access is asking me for (Row headings, Column
heading & Value option). Every time I try to assign a heading to a field is
giving me an error so I'm stuck. Can you help???

"Douglas J. Steele" wrote:

You should be able to create a Crosstab Query that arranges the data like
that, and use that Crosstab Query as the basis for a report.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Santi" wrote in message
...
Hi,
I have a table in access that contains product numbers, prices and these
prices are based on location. This information is all going down, but what
I
would like to do is to create a report showing each product going down but
showing prices going across depending on the location. Below is an example
of
what I'm trying to achieve so if anyone is able to help me I would really
appreciate it.

**EXAMPLE **
Product # Description EastCoast Midwest South
West
123545 Ford Escape 15,000 14,000 12,000
16,000
13254 Ford Fusion 27,000 25,000 24,000
28,000

Hello Santi,

Create a query named QryCrosstabBasis that has all the tables to get
ProductNumber, Description, Location and Price. Use the crosstab query
wizard and select QryCrosstabBasis as the data source. Follow the
instructions and set ProductNumber and Description for Row Headings,
Location for Column Headings and Price as Value. For Value select First.

Steve



"Santi" wrote in message
...
Douglas,

Thank you for the information, but I have little experience with the
Crosstab Query. What steps do I need to take to make this happen? I tried
doing this on my own but Access is asking me for (Row headings, Column
heading & Value option). Every time I try to assign a heading to a field
is
giving me an error so I'm stuck. Can you help???

"Douglas J. Steele" wrote:

You should be able to create a Crosstab Query that arranges the data like
that, and use that Crosstab Query as the basis for a report.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Santi" wrote in message
...
Hi,
I have a table in access that contains product numbers, prices and
these
prices are based on location. This information is all going down, but
what
I
would like to do is to create a report showing each product going down
but
showing prices going across depending on the location. Below is an
example
of
what I'm trying to achieve so if anyone is able to help me I would
really
appreciate it.

**EXAMPLE **
Product # Description EastCoast Midwest South
West
123545 Ford Escape 15,000 14,000 12,000
16,000
13254 Ford Fusion 27,000 25,000 24,000
28,000