Creating a Query in Access with user selection from multiple Table

G

Guest

I have a table in Access which contains multiple columns containing data, one
column for each of 28 different branches.

I wish to create a query so that values from the table can be displayed for
individual branches as selected by the user of the query.

How can I set a "criteria" to select just one column when the query is run
without using further queries?
 
T

Tom Ellison

Dear Phil:

There are a lot of good reasons why this is a very bad thing.

The table should have 2 columns where you have 28 columns. One column
should identify the branch, and the other column should contain the
value for that branch.

You are now experiencing the pain of trying to write queries for
improperly designed data. Can I help you fix the data first? The
query will then be pretty simple.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Wed, 24 Nov 2004 08:19:02 -0800, Phil from Hardings <Phil from
 

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

query return only one row with averages 4
Multiple Parameter Crosstab query filter by form 1
Insert Multiple Records into a Table 1
Multiple Values in a Query Criteria 1
Set Query Criteria based on selection from Form 1
Passing the output of a query to a table 4
Indexed columns when joining query with query ??? 3
Quering a drop down column from a table 2

Top