Ability to format SQL so it's easier to read (1 Viewer)

T

thardyjackson

Registered User.
Local time
Today, 04:39
Joined
May 27, 2013
Messages
45
Is there an add-in or some way to format my SQL like adding line breaks, etc. It's hard to review and debug when I have one long sequence. I'll add carriage returns but they aren't saved when I reload the sql.

Thanks

MS Access 2010
 
G

Galaxiom

Super Moderator
Staff member
Local time
Today, 21:39
Joined
Jan 20, 2009
Messages
12,851
We all wish for this, and the supression of those confounded parentheses that Access insists in including.

If I am designing a complex query structure I will sometimes edit it in Notepad and paste it over to the SQL view.
 
You must log in or register to reply here.

Similar threads

B
VBA problem relating to SQL linked table
Replies
6
Views
515
CJ_London
C
M
How to populate a junction table? Take 2
Replies
7
Views
350
Missomissou
M
Z
Assistance - Issue with Expression Function in SQL Query and Invoking Function in VBA Editor
Replies
4
Views
425
June7
June7
D
SQL data source credentials error
Replies
12
Views
735
dtdukes86
D
C
Access Studio - formatted SQL and more
Replies
0
Views
966
CJ_London
C

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom