SEARCH TWO FIELDS-MATCH BOTH

  • Thread starter Thread starter Jan via AccessMonster.com
  • Start date Start date
J

Jan via AccessMonster.com

In the query criteria of field Description1 I have Like [Enter Description
1] & "*" and stepped down in the OR criteria for Description2 I have Like
[Enter Description 2] & "*". The user needs to be able to "global" search
the fields but as I have the criteria set it seems to list "either/Or" . I
want it to find only records that match Description1 and Description2.
Example: If the user enters "Pencil" then "Red" I only want records that
have Pencil in the first description field AND Red in the second.

I've search the query threads but have not found this example requested yet.

Thanks
 
Then put the criteria on the same row in the design grid to create and "AND"
condition. Separate rows create "OR" conditions.
 
Jan said:
In the query criteria of field Description1 I have Like [Enter Description
1] & "*" and stepped down in the OR criteria for Description2 I have Like
[Enter Description 2] & "*". The user needs to be able to "global" search
the fields but as I have the criteria set it seems to list "either/Or" . I
want it to find only records that match Description1 and Description2.
Example: If the user enters "Pencil" then "Red" I only want records that
have Pencil in the first description field AND Red in the second.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Both criteria should be on the same line, that will give the AND
evaluation.

Description1 Description2
Like [Enter Description1] & "*" Like [Enter Description2] & "*"

Switch to the SQL view & look at the WHERE clause it should look like
this:

WHERE Description1 Like [Enter Description1] & "*" AND Description2 Like
[Enter Description2] & "*"

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRFJsQ4echKqOuFEgEQKfDACglgYOHQkmfIB5ufQwg7PfsD56phQAniIc
0ShbUbOcW57AMQxpIb88tALw
=1o2P
-----END PGP SIGNATURE-----
 
Thank you both for replying. This forum has taught me so much and has been
so helpful with my development of db's.
In the query criteria of field Description1 I have Like [Enter Description
1] & "*" and stepped down in the OR criteria for Description2 I have Like
Click to expand...
[quoted text clipped - 3 lines]
Example: If the user enters "Pencil" then "Red" I only want records that
have Pencil in the first description field AND Red in the second.
Click to expand...

Both criteria should be on the same line, that will give the AND
evaluation.

Description1 Description2
Like [Enter Description1] & "*" Like [Enter Description2] & "*"

Switch to the SQL view & look at the WHERE clause it should look like
this:

WHERE Description1 Like [Enter Description1] & "*" AND Description2 Like
[Enter Description2] & "*"
Click to expand...
 
Back
Top