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
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