By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,306 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

ID number from a Lookup

P: n/a
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 }
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.