Solved Please guide about between comparison in IIF fuction for Calculated Field.

[Khurramshaikh47]

Please Guide! I am using the (calculated data type) field in the Microsoft Access table
Field Names:

1. Value (For Input Values)
2. Output (For the result)

IF Value is between 6 and 7 truepart should 8 falsepart should 0.
What should the syntax this? I am confused in "between comparison".


Thank you!

 

[theDBguy]

Hi. You could try something like this.

IIf([FieldName]>=6 AND [FieldName]<=7,8,0)

Hope that helps...

 

[Khurramshaikh47]

Hi. You could try something like this.

IIf([FieldName]>=6 AND [FieldName]<=7,8,0)

Hope that helps...

Thank you so much my issue is solved!

 

[theDBguy]

Thank you so much my issue is solved!

Hi. You're welcome. Good luck with your project.