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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Converting SQL View into Access Query
- Thread starter Tarbuza
- Start date
If it's the mechanics you're looking for...
Open a new query design window with no tables shown
Use menus to switch he view to SQL
(one word will be highlighted) paste in the SQL statement
Use the menu to switch back to query design view.
If there is a prblem with the code it wil give you an indication of the bit it doesn't like.
HTH
Telephoto
Open a new query design window with no tables shown
Use menus to switch he view to SQL
(one word will be highlighted) paste in the SQL statement
Use the menu to switch back to query design view.
If there is a prblem with the code it wil give you an indication of the bit it doesn't like.
HTH
Telephoto
If it's the mechanics you're looking for...
Open a new query design window with no tables shown
Use menus to switch he view to SQL
(one word will be highlighted - lose it) paste in the SQL statement
Use the menu to switch back to query design view.
If there is a problem with the code it will give you an indication of the bit it doesn't like.
HTH
Telephoto
Open a new query design window with no tables shown
Use menus to switch he view to SQL
(one word will be highlighted - lose it) paste in the SQL statement
Use the menu to switch back to query design view.
If there is a problem with the code it will give you an indication of the bit it doesn't like.
HTH
Telephoto
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question