reference a field by value contained in another table.

M

Michael Warne

I am having a problem trying to reference a field when the fieldname is
a value within another table.

ie
table a
item id autonumber. key
item_field text
item_name text


table b
datename datetime,
it1 number,
it2 number,
it3 number,
it4 number,
it5 number,
it6 number


I wish to create a query that uses the value [a].[item_field] to
reference .([a].[item_field])

any help would be appreciated.


thanks

mike
 
L

Larry

-----Original Message-----
I am having a problem trying to reference a field when the fieldname is
a value within another table.

ie
table a
item id autonumber. key
item_field text
item_name text


table b
datename datetime,
it1 number,
it2 number,
it3 number,
it4 number,
it5 number,
it6 number


I wish to create a query that uses the value [a]. [item_field] to
reference .([a].[item_field])

any help would be appreciated.


thanks

mike

.
you need the field [item_field] in table b
Click to expand...
 

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

Checking if data exists another table and, if yes, extracting a value 0
Create IN criteria from another table 1
Access Macro Repeat Expression using value of a field in table 0
Using a field reference in a query critereon 0
Increment field by 1 on insert Query 2
Fixing up field with a row number to become PK 1
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Cross Reference field displays entire table instead of just thecaption name 2

Top