Can Access process a query with partial field information?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that supplies the parameters to a query. Can I set this to
query the database if partial information is entered? For example, the user
enters "smi" and the query returns all records that =, begin with and/or
include those letters.
 
Andrea said:
I have a form that supplies the parameters to a query. Can I set this to
query the database if partial information is entered? For example, the user
enters "smi" and the query returns all records that =, begin with and/or
include those letters.
Click to expand...

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

Read the Access Help articles on the LIKE predicate.

Starts with:

WHERE column_name Like "smi*"

Includes:

WHERE column_name Like "*smi*"

Equals:

WHERE column_name = "smi"

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

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

iQA/AwUBRFJwD4echKqOuFEgEQJcqACeLi9IcUrMq58J9+aXIB0K2QrRhYsAn3qd
MdIa0eCVubFThMr9WXAm1KJe
=IYuF
-----END PGP SIGNATURE-----
 
Back
Top