Query changes drastically complex after saving and reopening

[Vindicator]

Hi There
I have a somewhat simple query, that once saved and re-opened MS Access changes the programming to be drastically longer and more complex. It still works as it should, but as soon as I tamper with it, it no longer runs. It states (and rightly so) the query is too complex.
The query is a search query linked to a Form, which in turn acts as an Sub-Form.
Is there a way to stop Access from auto-correcting, as I think this is the problem? Or is this a known problem and the error lies with my design.

I could show the SQL before and after. Needless to say the SQL goes from being around 12 lines to around 247 lines!!!

 

[MSAccessRookie]

Hi There
I have a somewhat simple query, that once saved and re-opened MS Access changes the programming to be drastically longer and more complex. It still works as it should, but as soon as I tamper with it, it no longer runs. It states (and rightly so) the query is too complex.
The query is a search query linked to a Form, which in turn acts as an Sub-Form.
Is there a way to stop Access from auto-correcting, as I think this is the problem? Or is this a known problem and the error lies with my design.

I could show the SQL before and after. Needless to say the SQL goes from being around 12 lines to around 247 lines!!!

As for turning off what Access is doing, I have never heard if any such ability. There are too many possibilities to guess what is going on, so if you want to show us the SQL before and after then perhaps we can help you to figure out alternatives.

 

[Vindicator]

Thank you for your time and consideration, I wont blame you if you give up though. This really doesnt make any sense to me whatsoever.

Basically i have two tables linked and fields from both. In 5 fields I have criteria such as:

[Forms].[Main Switch-board].[LMMut1] Or [Forms].[Main Switch-board].[LMMut1] Is Null)

In this case LMMut1 being a field from one of the tables and "Main Switch-board" containing a search.

Below is the whole SQL before everything goes to heck. Im not sure you want to even look at the changed SQL as its jibberish being 20x longer. It seems that the new SQL seperates out the statements between the "Or" and for each other "Or" from other fields criteria multiplies the amount of statements (Hard to describe):

SELECT [general demographics].pt_id, [general demographics].dob, DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd")) AS Age, [general demographics].mut_1, [general demographics].mut_2, [Lung Function Non-Exace Associated].datepft, [Lung Function Non-Exace Associated].fevvalue, [Lung Function Non-Exace Associated].fevpred
FROM [general demographics] INNER JOIN [Lung Function Non-Exace Associated] ON [general demographics].pt_id = [Lung Function Non-Exace Associated].pt_id
WHERE ((((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) Or [Forms].[Main Switch-board].[LMMinAge] Is Null Or [Forms].[Main Switch-board].[LMMaxAge] Is Null) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1]) Or [Forms].[Main Switch-board].[LMMut1] Is Null) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2]) Or [Forms].[Main Switch-board].[LMMut2] Is Null) AND ((([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) Or [Forms].[Main Switch-board].[LMMinFev] Is Null Or [Forms].[Main Switch-board].[LMMaxFev] Is Null) AND ((([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) Or [Forms].[Main Switch-board].[LMMinPredFev] Is Null Or [Forms].[Main Switch-board].[LMMaxPredFev] Is Null));

 

[MSAccessRookie]

This is a very complex query, but it looks structurally sound. I would like to make the following observations:

• Many of the Column Names, Table Names, and Form Names contain special characters (Spaces, "-", etc). As a rule names using these characters should be avoided if possible.
• Many of the Column Names, Table Names, and Form Names are very long (for descriptive purposes, I assume. If there are any character limitations within Access (at present, I am not aware of any), this could use issues. In this query, using Aliases for the Tables, could save over 350 characters.

Having said these things, I have no reason to believe that they are the issue. I know that is is long, but can we see the AFTER picture?

 

[Vindicator]

Yeah I dont think those are the real issues. I am rather descriptive with my naming. Thanks for highlighting the special characters problem. I think it is a good idea I get rid of those.

Erm I cant post it all in one go as im limited to 25000 characters.
Anyways here is the new code Access threw at me. Gulp... it may be more entertaining to see than useful haha.

SELECT [general demographics].pt_id, [general demographics].dob, DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd")) AS Age, [general demographics].mut_1, [general demographics].mut_2, [Lung Function Non-Exace Associated].datepft, [Lung Function Non-Exace Associated].fevvalue, [Lung Function Non-Exace Associated].fevpred
FROM [general demographics] INNER JOIN [Lung Function Non-Exace Associated] ON [general demographics].pt_id = [Lung Function Non-Exace Associated].pt_id
WHERE (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev])) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general
demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main
Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR ((([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general

 

[Vindicator]

AND THE REST OF THE CODEING:


demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevpred) Between [Forms].[Main Switch-board].[LMMinPredFev] And [Forms].[Main Switch-board].[LMMaxPredFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR ((([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMinPredFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([Lung Function Non-Exace Associated].fevvalue) Between [Forms].[Main Switch-board].[LMMinFev] And [Forms].[Main Switch-board].[LMMaxFev]) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main
Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMinFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_2)=([Forms].[Main Switch-board].[LMMut2])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([general demographics].mut_1)=([Forms].[Main Switch-board].[LMMut1])) AND (([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR (((DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd"))) Between [Forms].[Main Switch-board].[LMMinAge] And [Forms].[Main Switch-board].[LMMaxAge]) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([Forms].[Main Switch-board].[LMMinAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null)) OR ((([Forms].[Main Switch-board].[LMMaxAge]) Is Null) AND (([Forms].[Main Switch-board].[LMMut1]) Is Null) AND (([Forms].[Main Switch-board].[LMMut2]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxFev]) Is Null) AND (([Forms].[Main Switch-board].[LMMaxPredFev]) Is Null));

 

[Vindicator]

SOLVED!! Re: Query changes drastically complex after saving and reopening

!!SOLVED!!

I believe I have solved my problem. Instead of creating the query in the design view I coded straight in the SQL section. I also coded in the SQL section so the criteria would be in their own columns if one were to look at the design view again.
I believe this separation of the criteria from their corresponding fields stops Access from going crazy and changing everything making it soo complicated.
Thanks for the help! If you want to see how the SQL turned out differently here it is:

SELECT [general demographics].pt_id, [general demographics].dob, DateDiff("yyyy",[general demographics].[dob],[datepft])+(Format([datepft],"mmdd")<Format([general demographics].[dob],"mmdd")) AS Age, [general demographics].mut_1, [general demographics].mut_2, [Lung Function Non-Exace Associated].datepft, [Lung Function Non-Exace Associated].fevvalue, [Lung Function Non-Exace Associated].fevpred
FROM [general demographics] INNER JOIN [Lung Function Non-Exace Associated] ON [general demographics].pt_id=[Lung Function Non-Exace Associated].pt_id

WHERE (((DateDiff("yyyy",[general demographics].dob,[datepft])+(Format([datepft],"mmdd")<Format([general demographics].dob,"mmdd"))>=Forms.[Main Switchboard].LMMinAge And DateDiff("yyyy",[general demographics].dob,[datepft])+(Format([datepft],"mmdd")<Format([general demographics].dob,"mmdd"))<=Forms.[Main Switchboard].LMMaxAge Or Forms.[Main Switchboard].LMMinAge Is Null Or Forms.[Main Switchboard].LMMaxAge Is Null)=True)

And (([mut_1]=Forms.[Main Switchboard].LMMut1 Or Forms.[Main Switchboard].LMMut1 Is Null)=True)

And (([mut_2]=Forms.[Main Switchboard].LMMut2 Or Forms.[Main Switchboard].LMMut2 Is Null)=True)

And ((([fevvalue]>=Forms.[Main Switchboard].LMMinFev And [fevvalue]<=Forms.[Main Switchboard].LMMaxFev) Or Forms.[Main Switchboard].LMMinFev Is Null Or Forms.[Main Switchboard].LMMaxFev Is Null)=True)

And ((([fevpred]>=Forms.[Main Switchboard].LMMinPredFev And [fevpred]<=Forms.[Main Switchboard].LMMaxPredFev) Or Forms.[Main Switchboard].LMMinPredFev Is Null Or Forms.[Main Switchboard].LMMinPredFev Is Null)=True));