DLookup to match fields that are not the same

S

SailorRoy

I have two tables that contain part numbers that I want to match. First
table has a job number, part number, and time entered daily. Second table is
exported from PeachTree Accounting program that has an extended part number
for colorcodes etc. I am trying to return part discription information from
that table. Can this be done and can anyone help me. Thanks

Roy
 
S

SailorRoy

Inventory: DLookUp("[Item Description]","[Inventory]","[Item ID]='" & [Part]
& "'")
 
B

Bob Quintal

=?Utf-8?B?U2FpbG9yUm95?= <[email protected]>
wrote in
Inventory: DLookUp("[Item Description]","[Inventory]","[Item
ID]='" & [Part] & "'")

SailorRoy said:
I have two tables that contain part numbers that I want to
match. First table has a job number, part number, and time
entered daily. Second table is exported from PeachTree
Accounting program that has an extended part number for
colorcodes etc. I am trying to return part discription
information from that table. Can this be done and can anyone
help me. Thanks

Roy
Click to expand...
Click to expand...

This will not match your 'extended part number' if you want to
match part FX12345 with FX12345-Red then change the criteria to
"[Item > ID] like'" & [Part] & "*'")
 
Top