keep query sql formatting

[diegomarino]

Sorry, maybe a silly question but i'd like to keep the sql formatted as i did, like in the pic






moreover, i made a query in which the WHERE clause was so easy, then after i reopened it i saw this madness you can see below. How can i keep my old WHERE clause? i wrote it in SQL of course, should i use VBA?

WHERE (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data inizio trattativa])>=[FORMS]![Trattativeoverview].[datainiziotb]) AND ((Trattative.[Data fine trattativa])<=[FORMS]![Trattativeoverview].[datafinetb]) AND ((Trattative.StatoTrattativa)=[FORMS]![Trattativeoverview].[statotrattativacb]) AND (((SELECT Max(Calendario.[Data inizio]) FROM partecipanti INNER JOIN Calendario ON partecipanti.calendarioid = calendario.idcalendario WHERE calendario.completato = false AND partecipanti.partecipanteid = trattative.candidatoid))<=[FORMS]![Trattativeoverview].[proxcontattotb])) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data fine trattativa])<=[FORMS]![Trattativeoverview].[datafinetb]) AND ((Trattative.StatoTrattativa)=[FORMS]![Trattativeoverview].[statotrattativacb]) AND (((SELECT Max(Calendario.[Data inizio]) FROM partecipanti INNER JOIN Calendario ON partecipanti.calendarioid = calendario.idcalendario WHERE calendario.completato = false AND partecipanti.partecipanteid = trattative.candidatoid))<=[FORMS]![Trattativeoverview].[proxcontattotb]) AND (([FORMS]![Trattativeoverview].[datainiziotb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data inizio trattativa])>=[FORMS]![Trattativeoverview].[datainiziotb]) AND ((Trattative.StatoTrattativa)=[FORMS]![Trattativeoverview].[statotrattativacb]) AND (((SELECT Max(Calendario.[Data inizio]) FROM partecipanti INNER JOIN Calendario ON partecipanti.calendarioid = calendario.idcalendario WHERE calendario.completato = false AND partecipanti.partecipanteid = trattative.candidatoid))<=[FORMS]![Trattativeoverview].[proxcontattotb]) AND (([FORMS]![Trattativeoverview].[datafinetb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.StatoTrattativa)=[FORMS]![Trattativeoverview].[statotrattativacb]) AND (((SELECT Max(Calendario.[Data inizio]) FROM partecipanti INNER JOIN Calendario ON partecipanti.calendarioid = calendario.idcalendario WHERE calendario.completato = false AND partecipanti.partecipanteid = trattative.candidatoid))<=[FORMS]![Trattativeoverview].[proxcontattotb]) AND (([FORMS]![Trattativeoverview].[datainiziotb]) Is Null) AND (([FORMS]![Trattativeoverview].[datafinetb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data inizio trattativa])>=[FORMS]![Trattativeoverview].[datainiziotb]) AND ((Trattative.[Data fine trattativa])<=[FORMS]![Trattativeoverview].[datafinetb]) AND (((SELECT Max(Calendario.[Data inizio]) FROM partecipanti INNER JOIN Calendario ON partecipanti.calendarioid = calendario.idcalendario WHERE calendario.completato = false AND partecipanti.partecipanteid = trattative.candidatoid))<=[FORMS]![Trattativeoverview].[proxcontattotb]) AND (([FORMS]![Trattativeoverview].[statotrattativacb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data fine trattativa])<=[FORMS]![Trattativeoverview].[datafinetb]) AND (((SELECT Max(Calendario.[Data inizio]) FROM partecipanti INNER JOIN Calendario ON partecipanti.calendarioid = calendario.idcalendario WHERE calendario.completato = false AND partecipanti.partecipanteid = trattative.candidatoid))<=[FORMS]![Trattativeoverview].[proxcontattotb]) AND (([FORMS]![Trattativeoverview].[datainiziotb]) Is Null) AND (([FORMS]![Trattativeoverview].[statotrattativacb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data inizio trattativa])>=[FORMS]![Trattativeoverview].[datainiziotb]) AND (((SELECT Max(Calendario.[Data inizio]) FROM partecipanti INNER JOIN Calendario ON partecipanti.calendarioid = calendario.idcalendario WHERE calendario.completato = false AND partecipanti.partecipanteid = trattative.candidatoid))<=[FORMS]![Trattativeoverview].[proxcontattotb]) AND (([FORMS]![Trattativeoverview].[datafinetb]) Is Null) AND (([FORMS]![Trattativeoverview].[statotrattativacb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND (((SELECT Max(Calendario.[Data inizio]) FROM partecipanti INNER JOIN Calendario ON partecipanti.calendarioid = calendario.idcalendario WHERE calendario.completato = false AND partecipanti.partecipanteid = trattative.candidatoid))<=[FORMS]![Trattativeoverview].[proxcontattotb]) AND (([FORMS]![Trattativeoverview].[datainiziotb]) Is Null) AND (([FORMS]![Trattativeoverview].[datafinetb]) Is Null) AND (([FORMS]![Trattativeoverview].[statotrattativacb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data inizio trattativa])>=[FORMS]![Trattativeoverview].[datainiziotb]) AND ((Trattative.[Data fine trattativa])<=[FORMS]![Trattativeoverview].[datafinetb]) AND ((Trattative.StatoTrattativa)=[FORMS]![Trattativeoverview].[statotrattativacb]) AND (([FORMS]![Trattativeoverview].[proxcontattotb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data fine trattativa])<=[FORMS]![Trattativeoverview].[datafinetb]) AND ((Trattative.StatoTrattativa)=[FORMS]![Trattativeoverview].[statotrattativacb]) AND (([FORMS]![Trattativeoverview].[datainiziotb]) Is Null) AND (([FORMS]![Trattativeoverview].[proxcontattotb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data inizio trattativa])>=[FORMS]![Trattativeoverview].[datainiziotb]) AND ((Trattative.StatoTrattativa)=[FORMS]![Trattativeoverview].[statotrattativacb]) AND (([FORMS]![Trattativeoverview].[datafinetb]) Is Null) AND (([FORMS]![Trattativeoverview].[proxcontattotb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.StatoTrattativa)=[FORMS]![Trattativeoverview].[statotrattativacb]) AND (([FORMS]![Trattativeoverview].[datainiziotb]) Is Null) AND (([FORMS]![Trattativeoverview].[datafinetb]) Is Null) AND (([FORMS]![Trattativeoverview].[proxcontattotb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data inizio trattativa])>=[FORMS]![Trattativeoverview].[datainiziotb]) AND ((Trattative.[Data fine trattativa])<=[FORMS]![Trattativeoverview].[datafinetb]) AND (([FORMS]![Trattativeoverview].[statotrattativacb]) Is Null) AND (([FORMS]![Trattativeoverview].[proxcontattotb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data fine trattativa])<=[FORMS]![Trattativeoverview].[datafinetb]) AND (([FORMS]![Trattativeoverview].[datainiziotb]) Is Null) AND (([FORMS]![Trattativeoverview].[statotrattativacb]) Is Null) AND (([FORMS]![Trattativeoverview].[proxcontattotb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND ((Trattative.[Data inizio trattativa])>=[FORMS]![Trattativeoverview].[datainiziotb]) AND (([FORMS]![Trattativeoverview].[datafinetb]) Is Null) AND (([FORMS]![Trattativeoverview].[statotrattativacb]) Is Null) AND (([FORMS]![Trattativeoverview].[proxcontattotb]) Is Null)) OR (((Trattative.Nostra)=[FORMS]![Trattativeoverview].[nostrachb]) AND (([FORMS]![Trattativeoverview].[datainiziotb]) Is Null) AND (([FORMS]![Trattativeoverview].[datafinetb]) Is Null) AND (([FORMS]![Trattativeoverview].[statotrattativacb]) Is Null) AND (([FORMS]![Trattativeoverview].[proxcontattotb]) Is Null));

thanks

[June7]

If you save the query from SQL view with structure you prefer and never open in design view, it might retain that structure.

[diegomarino]

thanks, i think this works only for where clause, not for the text formatting of sql. Just tried.
however it's good enogh, thanks

[Welshgasman]

Personally I think the the picture is madness.
I am all for spacing clearly, but that is awful.

[kd2017]

I agree it's pretty annoynng that access loses your formatting... I also agree that your formatting is quite difficult to read.

When I need to read an sql statement I just copy and paste it in an online sql formater. I usually use this one: https://www.dpriver.com/pp/sqlformat.htm
You can play with formatting options and it will do syntax highlighting. You can also set it to output a VB string that's handy for hard coding queries

[June7]

I use Notepad++ for a quick check of paren pairing and highlight key words.

[diegomarino]

thanks for the online formatter and....
what you see like madness is purely wisdom, but your small soul cannot recognize it

stop joking, i like my format cause it makes so easy to read the joins, you can see that ON is alway under the relative JOIN

thanks everyone

[diegomarino]

well, i tried the online formatter. It's definely better