Access Question

TheeOx

In Runtime
Messages
119
Location
Hi
Hi all.
A silly question, but one I need to ask -
whats the best way to do a query in Access?
Are there any sure fire formulas, etc?

Please advise.
Thanks,
Thee :rolleyes:

Happy New Year!
 

wozelbeak

Daemon Poster
Messages
1,324
well i have some basic knowledge of this. so i will tell you what i know.
i take it that you have filled in your fields and created your table.
minimize your table and select querys. then out of the pop up select create query in design view.
it will the pop up with "show table", select add. you will then have your query table. you add your fields with the little drop down menu.
you can then create your query. you leave the box ticked in each feild you would like the query to applie to.

wozelbeak
 

TheeOx

In Runtime
Messages
119
Location
Hi
Yes!!

Yes,
please advise on how to do an advanced query.

And THANKS wozelbeak for your answer.
I trully appreciate yer help.

Thee :p :D
 

technoman2

Fully Optimized
Messages
3,382
so you can do normal query's right? anyway you need to create 2 or more tables to search through the tables, once you have done that setting up and advanced query's are easy. i will write a quick help file later becasue i have to be going .. lol , soz
 
Top