Select Criterion - wildcard

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

Guest

Have a query with addresses - need the user ot be able to enter just the
street numbers and see all addresses with said numbers. Such as:"836" gives
them 836, 8365, 836009 from the table. Not sure how to use a wildcard with a
select criterion. Simple have [Address Number?] right now - it only pulls
exact matches. Have to do this in design view - dont know vba.

--
Regards,

Bryan Brassell
Padgett Business Services
281-897-9141
 
FieldName LIKE Forms!formName!controlName & "*"

or

FieldName LIKE Forms!formName!controlName & "%"


are the possible criteria (* by default, with Jet ). In the query designer,
bring the field name in the grid, and, there, under it, at the criteria
line, type

LIKE Forms!formName!controlName & "*"


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top