I have a few calculation problems

[stryder09]

So the reason I keep posting this is because I was asked to create a databse from an excel spreadsheet. Unfortunately the excel calculations dont always work in the access enviroment. Here is another one that won't work for me.

This is the excel calculation
=If([AveragePHMeasured]=0,0,If(Or([AveragePHMeasured]>6.4,[AveragePHMeasured]<5.5),5,0))




This is the calculation I built for Access
=IIF([AveragePHMeasured]=0,0,IIF(Or([AveragePHMeasured]>6.4,[AveragePHMeasured]<5.5),5,0))

I get the error back

The expression you entered contains invalid syntax
You may have entered a comma without proceeding value or identifier.

Any help would be appreciated. Unfortunately I will probably have a few more questions after this one.

Thanks

Brad

[TheShabz]

=IIF([AveragePHMeasured]=0,0,IIF([AveragePHMeasured]>6.4 OR [AveragePHMeasured]<5.5,5,0))

Give that a whirl

[stryder09]

Thanks worked perfectly, one down many to go.

[TheShabz]

Anytime. Go ahead and mark the thread as "solved" please so that others can search for it.

[stryder09]

not sure how to mark as solved?

[TheShabz]

it's under the "thread tools"