DLookup to match fields that are not the same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=?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] & "*'")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Dlookup 7
A challenge for a report guru 3
Query to list records that don't match 6
Partial field matches in a report 1
Finding possible matches 8
Use DLookUp to Enter Data into a Table 3
Auto-Populate Form Field 1

Back
Top