How Can I get this query to work?

[Santi]

Hi,

I’m having a hardtime trying to build the query listed below. Can anyone let
me know how should I structure the following information in Access so my end
result is a report like the one below? I would really appreciate any help.

Example:

I have two tables

Table 1 (Prices Table)
Contains the following fields
Item number
Product Description
Price
Price based on State

Table 2 (Locations table)
Contains the following fields
Locations
Brand
Active Location based on County (Yes/No)


End Result
I want a report that contains:

Item number
Brand
Product Description
Price
Price based on region

 

[Jeff Boyce]

I don't see how you are connecting the two tables. How are you defining
"region"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Santi]

mmm, I'm probably not setting up the relationship correctly so I'm thinking
the problem might be just that connecting the two tables the right way. I
just can seem to find the right field to add to make these two tables merge.
I want to be able to select information based on State and also on region.
The report I want should be able to give me prices based on state then on
region if I want to.

 

[Jeff Boyce]

Again, I'm not seeing in your description of the tables/fields anything that
looks like "Region". I believe you'd need a way to show which states (or
locations, or ...) were considered to be in which "regions".

Regards

Jeff Boyce
Microsoft Office/Access MVP