Please help with my query query!

[1masc]

Morning everyone!

Is it possible to create a query that searches more than one field with the same criteria entered in a single entry box?
If it is not could someone put me out of my misery!!
Otherwise any help would be great!

Thanks in advance!

 

[Michael J Ross]

Yes, If I'm understanding you right you want to search several fields using the same criteria.

You need to create a form with a text box to enter the criteria and then in your query under each of the fields you want to search on put the criteria [Forms]![Nameofyourform]![Nameofyourtextfield]

 

[1masc]

Thanks Michael,

Could you tell me how to link the text box to the query so that once the criteria has been entered I can click a button to run the query?

Apologies for my incompetence, and many thanks for your help!

 

[Michael J Ross]

No need to apologise.

To create the command button, in your form design click on the ToolBox icon on your toolbar (if its not there you will need to add it using View;Toolbars;Customise) , in toolbox click on Command Button and follow the wizard that pops up (Run Query is under Miscellaneous).

 

[1masc]

Thanks ever so much, could you tell me what prefix i need to insert in the criteria so that just part of the field needs to be inserted.
for example "lin" when searching for "lincolnshire"
Your help is massively appreciated as i have been struggling with this particular function for some time!

 

[Michael J Ross]

Like "*"&[Forms]![Nameofyourform]![Nameofyourtextfield]&"*"

 

[1masc]

All your help has been so useful, thank you!