Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Semi-stupid question, hopefully there's an easy answer

Status
Not open for further replies.
CHeighlund

CHeighlund

Programmer
Jun 11, 2007
163
US
Does Access have a direct query ability similar to the way that PostgreSQL and MySQL do, and if so, how would I go about getting to it? I'm getting back results on my program which don't seem to mesh up with the records I can actually see when I pop open the database to take a look, and I'm wondering how I'd check the results of my sql statements directly rather than through the medium of the program.
 
Sort by date Sort by votes
Not 100% sure I know what you are after, but have you tried viewing your query in SQL view? While in query design mode, go to View on the menu then choose SQL View.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
724
dhookom
dhookom
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
3K
lmcate
lmcate
ameedoo3000
  • Locked
  • Question
animation waiting
Replies
0
Views
365
ameedoo3000
ameedoo3000
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
680
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top