DLookup to match fields that are not the same

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SailorRoy - 28 Jun 2007 15:22 GMT

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

Reply to this Message

SailorRoy - 28 Jun 2007 15:36 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> Roy

Reply to this Message

Bob Quintal - 28 Jun 2007 22:31 GMT

> Inventory: DLookUp("[Item Description]","[Inventory]","[Item
> ID]='" & [Part] & "'")
[quoted text clipped - 8 lines]
>>
>> Roy

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

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message