Doing a search in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have a database with one table and a form of this table. Is there a
moderately simple way so have a search for this. For example, in the
Northwind database, there is a query which asks you to input some data for it
to find results. Hope you understand what I mean! Basically, I want to be
able to search this form or table using some kind of input for one of the
fields. Thanks!
 
Use this for query criteria --
[Enter your data for search]

or if you wish to search by putting in the first part --
Like [Enter your data for search] & "*"

or if you wish to search by putting in any part --
Like "*" & [Enter your data for search] & "*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Build search function in to a form 5
Access 2003 vs 2010 1
Access Need help in making asset history in my current database. 1
Help with VBScript/Access database 0
Combo box & Search Function 3
Best way to track availability in a form 0
Searching in VBA like the find function 3
Search access Macros, Forms and VBA code for a specific table references 2

Back
Top