Access Query Basic (1 Viewer)

[camaroltd82]

I know this may be a little bit of a simple request, but I really need some help. I am a network intern at a Chemical plant in Sauget IL. I am working on an Access database for our Storeroom. I am doing okay on forms, and navigation through my pages, but I can't figure out my queries. I need to be able to query a table with user input, and have it kick back matches. (Just like a search engine.) Thanks for any help

Mike Fischer
camaroltd82@msn.com

 

[Jack Cowley]

I do not know how may fields a user can search in as you didn't say so this article will cover one or more fields for searching.

http://support.microsoft.com/support/kb/articles/Q210/2/42.ASP?LN=EN-US&SD=gn&FR=0&qry=QBF&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

 

[Memnoch1207]

If you are wanting to use user input for a query then in Access go to HELP and type in "Parameter Queries"...it will tell you everything you need to know.