Comparing values in two tables and show result

[Marilee Haney via AccessMonster.com]

Hello! Here is my issue:

I have a list of child care providers, their contact information, and stats
in a table called tblproviders. I have clients request in another table.
I want to match up clients with providers that meet their criteria and to
bring up a list with the providers information on it. How would I go about
doing this. In laymans terms preferably! :-)

(not actual, just an idea)

tblProviders

fldName
fldCity Look-up/dropdown
fldPets Y/N
fldAccreditation Look-up/dropdown

tblClients

fldClientName
fldClientCity
fldClientPets
fldClientAccreditation

I want the name of all providers where city, pets, and accreditation fields
match the clients.

Please help, and please e-mail me! My address is

marileehaney[AT]hotmail[dot]com

Thanks

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

[Marilee Haney via AccessMonster.com]

I forgot to add, I don't want an entire list of who matches who, I want to
be able to push a button and run this report for 1 client at a time.
Thanks!

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

[Tom van Stiphout]

On Fri, 18 Mar 2005 15:41:36 GMT, "Marilee Haney via
AccessMonster.com" <fo***@AccessMonster.com> wrote:

A perfect match-up is found with an inner-join query. So if
P.City=C.City and P.Pets=C.Pets and P.CA=C.CA
then you have a perfect match.

If you want only 1 client, then that just adds one more element to
your WHERE clause:
.... where ClientID=x

-Tom.

Hello! Here is my issue:

I have a list of child care providers, their contact information, and stats
in a table called tblproviders. I have clients request in another table.
I want to match up clients with providers that meet their criteria and to
bring up a list with the providers information on it. How would I go about
doing this. In laymans terms preferably! :-)

(not actual, just an idea)

tblProviders

fldName
fldCity Look-up/dropdown
fldPets Y/N
fldAccreditation Look-up/dropdown

tblClients

fldClientName
fldClientCity
fldClientPets
fldClientAccreditation

I want the name of all providers where city, pets, and accreditation fields
match the clients.

Please help, and please e-mail me! My address is

marileehaney[AT]hotmail[dot]com

Thanks