How Can I get this query to work?

S

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
 
J

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
 
S

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW CAN I DO THIS? 1
Need To Automate Task 1
PLEASE HELP 2
Data Validation 1
Query to show latest price 2
How Can I do this? 3
Query to show latest price based on dates 2
How to make Crosstab query 2

Top