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?
Code:
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