ID number from a Lookup

[HB2]

I am using the mail merge statement below from an MS Database. I am
getting the ID number for Vendor and Manufacturer instead of the
desciption. Is there a way to change this?

Thank you.

{DATABASE \d "G:\\Orders2.mdb" \c "QUERY Requisition" \s "SELECT
[Account], [Asset], [Qty], [Mfr_ID], [Part], [Description],
[Price_Each], [Extended] FROM [Requisition]" \l "23" \b "191" \h }

[Pieter Linden]

bg******@comcast.net (HB2) wrote in message news:<e9**************************@posting.google. com>...

I am using the mail merge statement below from an MS Database. I am
getting the ID number for Vendor and Manufacturer instead of the
desciption. Is there a way to change this?

Thank you.

{DATABASE \d "G:\\Orders2.mdb" \c "QUERY Requisition" \s "SELECT
[Account], [Asset], [Qty], [Mfr_ID], [Part], [Description],
[Price_Each], [Extended] FROM [Requisition]" \l "23" \b "191" \h }

Dont use lookups. Put your data in a separate table and then create a
normal query. Wouldn't touch the things with a barge pole. Only time
I ever had occasion to see them, it was because someone else did it.
Took me forever to figure out the stupidest most straightforward thing
I've ever seen. It was absurd.

[HB2]

I already have my data in a seperate table. How to I use a query to pull it up?

Thanks
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

bg******@comcast.net (HB2) wrote in message news:<e9**************************@posting.google. com>...

I am using the mail merge statement below from an MS Database. I am
getting the ID number for Vendor and Manufacturer instead of the
desciption. Is there a way to change this?

Thank you.

{DATABASE \d "G:\\Orders2.mdb" \c "QUERY Requisition" \s "SELECT
[Account], [Asset], [Qty], [Mfr_ID], [Part], [Description],
[Price_Each], [Extended] FROM [Requisition]" \l "23" \b "191" \h }

Dont use lookups. Put your data in a separate table and then create a
normal query. Wouldn't touch the things with a barge pole. Only time
I ever had occasion to see them, it was because someone else did it.
Took me forever to figure out the stupidest most straightforward thing
I've ever seen. It was absurd.