how search within a field

[djcawthorne]

i have created an asset database for a school. i have made a query that search for a room but say, for example, i want to find the record for "room 32" the user has to put "room 32" in the search box. is there anyway for example if the user types "32" that the record will be found?

any help much appriciated

 

[addy]

In your query, in the criteria section for Room put the following:

Like "*" & [Enter Room Number] & "*"

This will do a wildcard search on the room number which they will be prompted to enter when they run the query.

 

[djcawthorne]

thanks very much! worked a treat!

 

[djcawthorne]

worked a treat! thanks