|
Re: SQL in Access 2007
Go to the database window (the one that says tables, queries, etc down the left hand side. If you can't see it, go to top menu, window and then unhide)
Click Queries, and then click new at the top.
Select design view
Click Close
In the menubar, goto View and then SQL view
You can enter your SQL in there and then click the exclamation mark to execute it
__________________
"We're not here for a long time, we're here for a good time" - Mike Ness (Social Distortion)
"Reach for the sky, 'cause tomorrow may never come" - Reach For The Sky (Social Distortion)
|