Re: Reconciling Two Unrelated Tables

[DanCole42]

Preaching to the choir. I, however, hold no sway over our accounting
department and the software they use. :(

How would I go about it with the like() and INSTR()?

Thanks!

On Jul 7, 12:46 pm, "bhicks11 via AccessMonster.c om" <u44327@uwe>
wrote:

Now you see why the database design is important and a unique ID is a good
idea!
>
You can try using the like() function or INSTR() in a query to find partsof
the name in the string.
>
Bonniehttp://www.dataplus-svc.com
>
>

[bhicks11 via AccessMonster.com]

Re: Reconciling Two Unrelated Tables

For the like function:

In the full name column put

like "*punctuatednam e*" '(of course use your names)

add the amount criteria and check your results.

Bonnie

http://www.dataplus-svc.com

In your query grid
DanCole42 wrote:

>Preaching to the choir. I, however, hold no sway over our accounting
>department and the software they use. :(
>
>How would I go about it with the like() and INSTR()?
>
>Thanks!
>
>On Jul 7, 12:46 pm, "bhicks11 via AccessMonster.c om" <u44327@uwe>
>wrote:

>Now you see why the database design is important and a unique ID is a good
>idea!

>[quoted text clipped - 3 lines]

>>
>Bonniehttp://www.dataplus-svc.com

--
Message posted via http://www.accessmonster.com