IIF function, multiple IIF

B

brispark

Joined
Jun 13, 2010
Messages
1
Reaction score
0
Hi,
Sorry Im a newbie and this is probably a stupid question

I am trying to write a query into a medical database, I need to assign a certain value to my raw data eg

Heart rate between 70 and 100 , 0 or between 101 and 120, 2 etc

I have tried writing a multiple IIF statement but it doesnt work any ideas?

I have tried HR: IIF([Heart rate]>70,0,IIF([heart rate]>100,2))
and

HR:IIF([Heart rate]>70 and 100,0,IIF(......

and also

HR;IIF([heart rate]>70 and [Heart rate] <100

but they all return error
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple IIf statement doesn't work - please help 0
Multiple IIf Statements Not Working 5
IIF with multiple requirement 8
Nested IIF Statement syntax(?) problem 4
Ranking based on Multiple Data Fields 10
IIF Statement in a Query 5
selecting null with an iif expression in criteria access 2k3 13
how do you nest IIF statement in query? 4

Top