Creating a Search Query in Microsoft Access

[marksparro]

I am farely new to using Microsoft Access. I have a bunch of data that i would like to be able to search through with Microsoft Access. I have imported all the data from an Excel spreadsheet into Access. Now i need to create something through access that allows me to enter a search string and Access pulls the results for me from my table. I would appreciate any help that someone could offer me on doing this. Thanks.

 

[DougP]

That's very easy its called a "query"
click the "Queries" TAB
then New to make a new query
Then you should see your tables
Add one table to start with.
Add all of the fields by clicking and draging or double clicking on each one.

Now just run it by pressing the Big RED exclamtoin mark

OK next click the Design button (looks like a cyan colored Drafting triagle in the upper left)
Now in one of your fields in the critera (lower part of screen) put in a valid number or name.

Run the query again click RED Exclamation mark
Stop it (click design triangle)

Now this is only the begining
I suggest you look in Help for examples of waht to type in

here are a few
Like [Enter some Value] & "*" 'returns wild card matches
= equal something
> greater than
< less than
<> not equal
Between something AND something else ' good for dates
Between [Enter Starting Date] AND [Enter Ending Date]

Access blows away a lot of other programs.
Welcome, you will love it!!!



DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[marksparro]

All the information you told me helps. I still have another question though. First, let me let you know what i have to do. I have 10 different fields. I would like to have a page pop up where it has all 10 fields listed and there is a blank box next to them. I want to be able to enter a search string in the box next to the field name, and it will search that field. For example, one of the 10 fields is called &quot;NSN&quot;. This field contains 16 numbers in each entry. I would like to be able to type in the first 5 numbers, and it would pop up all the items that had matched for those 5 numbers. Let me know if this is possible. Thanks.