I am relatively new to SQL coding, so pardon my ignorance.
When I write an SQL query in MS Access, I format it a certian way to make it easier to read. When I run the query and go back to my SQL code, often times Access has changed the format. Here is a simple example below.
I write:
SELECT
Table1.Field1
, Table1.Field2
FROM
Table1
WHERE
Table1.Field2 = “Yes”
I run the query and view the results. When I go back to my SQL code, it looks like this:
SELECT Table1.Field1, Table1.Field2
FROM Table1
WHERE (((Table1.Field2)=“Yes”));
Not a huge deal in this example, but as I write more complex queries the Access version of the code I wirte becomes a hot mess. Very difficult to read when editing. Is there some sort of setting I can change to force Access to retain the code format that I use when writing the SQL query?