Searching through ALL fields (1 Viewer)

[camaroltd82]

Is it possible to search through all fields of my table with a query? I have several searches by certain fields, but my user wants to be able to search through ALL of the available fields, is this possible?

thanks

Mike
camaroltd82@msn.com

 

[Hayley Baxter]

Yes you can do this by puting or like* in the criteria of your query. The * returns all records.

Just reading over your post again just realised you want to search on all fields and not the records in the one field. You could maybe try a Query by Form. I have an example of this if you're not sure.

Email me if you want this as it's too big in size to post

Hayley.Baxter@bskyb.com

Hay

 

[antomack]

Check the following post for a possible solution that might help you.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32034

 

[Pat Hartman]

There is something wrong with this picture. Why do you have multiple columns that could potentially contain the same data?