reference a field by value contained in another table.

  • Thread starter Thread starter Michael Warne
  • Start date Start date
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
 
-----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...
 
Back
Top