chuckcoleman
Registered User.
- Local time
- Today, 17:06
- Joined
- Aug 20, 2010
- Messages
- 357
I've run into a snag. I have a query that is based on one table, [BillingTable]. That table has a field, [ReferenceNoOriginal]. The data in that field might look like, TAX482-69511449. I have another table called, [TireCodeTable]. It has six rows with a field name of [TireCode]. The [TireCode] field has values like, TAX, PLT, STT, TAZ. There is no relationship between the two tables. I want to essentially use the LIKE function with DLookUp to produce records that start with the TireCode's in the [TireCodeTable]. I've done a lot of research but I can't find the right coding.
I will appreciate any thoughts.
Thanks,
Chuck
I will appreciate any thoughts.
Thanks,
Chuck