Select criteria

[crisp]

I'm an absaloute begginer at access!

I need to know if i can in a select query ask a user for a word to search for.

When i run the query a dialouge box shoud open asking for the search criterea and then searches multiple fields for the criteria.

For example the customer is prompted to specify part or all of a prouduct name or description, and the user enterd 'card 1' the query whoud return all records with only that in the name field or description field.

Im using acces 2000 if it means anything to anyone.

Thanks for reading this.

 

[dcx693]

Do a search of the fourms (and the Access on-line help) for "parameter query". Basically, you enter an expression into your query that looks something like this:
[Please enter the product name]
and when run, the query will prompt the user to input the info. If you want to query multiple fields at once, the trick is to use the exact same expression in the critieria line of multiple fields in your query. The user will only get prompted once for each unique expression. Another tip: combine those expressions with the Like operator to get approximate matches.

 

[crisp]

how simple!!

ive used that before i just didnt remember , ,i jut didnt no i choud do it accross multiple fields.

thanks.