By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,978 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,978 IT Pros & Developers. It's quick & easy.

Using String as Field

P: 1
I am using Access and would like to join two tables.
Table1 has 3 fields:
ID, Type, Date

Table2 has the following fields:
Date, Type1, Type2, ..., where each entry is Data.

What would be the best way to make to make a query returning ID, Type, Date, Data (where "Data" is from the field in Table2 with the same title as the value of the "Type" field in Table1)?

Jun 28 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
This is not the way relationships work. You are trying to join a field name to a field value. Have a look at this tutorial and see if it helps.

Database Normalization
Jul 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.