Why won't this formula work?

[BEI77]

I am a novice at Access. I am building a database to store and calculate vehicle A/C refrigerant test that will also diagnose the problem.

Here are my fields and formulas,

Ambient Temp
Low Side Press
High Side Press
LSP1
LSP1R



LSP1 is a calculated field with this formula, =IIF([Ambient Temp]=65, IIF([Low Side Press]<25,"LOW","") &""& IIF([Low Side Press]>35,"HIGH","")))

LSP1R is a calculated field that will give the result of the LSP1, =IIF([LSP1]=LOW,"Add Refrigerant","") &""& IIF([LSP1]=HIGH,"Needs Service",""))

I get a syntax error when I go to save the db. All help is appreciated.

[ArviLaanemets]

=IIF([Ambient Temp]=65, IIF([Low Side Press]<25,"LOW","") &""& IIF([Low Side Press]>35,"HIGH","")))

Lets take this formula apart

=Iif(Condition1, TrueResponse1, FalseResponse1)
Condition1 = [Ambient Temp]=65
TrueResponse1 = IIF([Low Side Press]<25,"LOW","") &""& IIF([Low Side Press]>35,"HIGH","")

TrueResponse1 = IIF(Condition11,TrueResponse11,FalseResponse11) & "" & IIF(Condition12,TrueResponse12,FalseResponse12)
Condition11 = [Low Side Press]<25
TrueResponse11 = "LOW"
FalseResponse11 = ""

Condition12 = [Low Side Press]>35
TrueResponse12 = "HIGH"
FalseResponse12 = ""

FalseResponse1 = )

How must Access calculate FalseResponse1! Especially when there is missing delimiter for FalseResponse1! Really you have formula

=Iif(Condition1, TrueResponse1))

I leave analyze of 2nd formula to you!

[Micron]

Advising against storing calculation in tables even if it did work. A form should return the decision/advice based on inputs of AmbientTemp, LSvalue and HSvalue as recorded. Acceptable HS and LS readings vary with ambient temp and gas type, correct? So are you intending to store every possible combination of acceptable high and low values for each given possible ambient temp and gas type? I should hope not. At most, you might store Pass/Fail given a TestID, but not in the same table as the diagnostic values. Note that I do not use spaces in my field name examples.