Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 01-07-2005, 11:08 AM   #1
Baseband Member
 
TheeOx's Avatar
 
Join Date: Sep 2004
Location: Ummmm CABBAGE LAND
Posts: 59
Send a message via AIM to TheeOx
Default Access Question

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

Happy New Year!
__________________

__________________
Animal Rights? They have one right - -
the right to taste good. That's right.
TheeOx is offline   Reply With Quote
Old 01-07-2005, 12:16 PM   #2
Daemon Poster
 
wozelbeak's Avatar
 
Join Date: Sep 2004
Posts: 1,324
Default Re: Access Question

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
__________________

__________________
PENTIUM 4 3.06 GHZ WITH HT TECHNOLOGY
wozelbeak is offline   Reply With Quote
Old 01-07-2005, 12:47 PM   #3
Fully Optimized
 
technoman's Avatar
 
Join Date: Dec 2004
Posts: 3,382
Default Re: Access Question

do you want to know how to do Advanced query?
__________________
~~~ tEcHnOmAn ~~~
technoman is offline   Reply With Quote
Old 01-08-2005, 12:19 PM   #4
Baseband Member
 
TheeOx's Avatar
 
Join Date: Sep 2004
Location: Ummmm CABBAGE LAND
Posts: 59
Send a message via AIM to TheeOx
Default Yes!!

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

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

Thee
TheeOx is offline   Reply With Quote
Old 01-08-2005, 12:24 PM   #5
Fully Optimized
 
technoman's Avatar
 
Join Date: Dec 2004
Posts: 3,382
Default Re: Access Question

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
__________________
~~~ tEcHnOmAn ~~~
technoman is offline   Reply With Quote
Old 01-08-2005, 12:35 PM   #6
Baseband Member
 
TheeOx's Avatar
 
Join Date: Sep 2004
Location: Ummmm CABBAGE LAND
Posts: 59
Send a message via AIM to TheeOx
Default Thanks

Thanks Techno..
I will look for your help file later.

Thee
__________________

TheeOx is offline   Reply With Quote
Reply

« SATA Power?? | AMDs »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 10:06 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0