access link to another database

[dbpcar]

I am trying to create a link to a seperate database that hold all possible inventory items so that the report will convert a stock # into the description. Only stock # are stored in the data base at present. I can get both the stock # and the description to report, but not the description only.

 

[Tim1]

Hiya,

It is very simple to remove the stock # from the report. On your query design screen, there is a column named "Show". If you uncheck this box for the stock # column, it will vanish from your output

 

[dbpcar]

WORKED LIKE A CHARM, MANY THANKS