I.D. vs. value

[marta]

Hello,
where I.D.# equals Value

I have a query that looks up Value based on the I.D.#
assigned to it. The query displays the data properly by
not showing the I.D.# but showing the Value assigned to it.
However, if I run a report pulling data from that query it
lists the I.D# not the Value. Is there any way to change
the report so that it displays the Value instead of the
I.D.#?

Thanks so much for your help!
Marta

 

[Duane Hookom]

You need to include the table that contains the Value and join the ID#
fields. Many of us recommend that you never ever use lookup fields in
tables. http://www.mvps.org/access/lookupfields.htm

 

[marta]

thank you

-----Original Message-----
You need to include the table that contains the Value and join the ID#
fields. Many of us recommend that you never ever use lookup fields in
tables. http://www.mvps.org/access/lookupfields.htm

--
Duane Hookom
MS Access MVP





.