Recent content by robbin

thank you so simple

I figured out how to put in 8 of the 13 numbers by simply using the horizontal lines in the query under "or" but how can I make more horizontal lines?

I don't think I told you my problem clearly. one line of data has up to 13 different numbers. I can either leave them in 13 different data boxes, or merge them into a single one. Either is possible. But I want the query to find a single number, and then print the corresponding patient name...

I have 13 fields of procedure codes for a single surgery. I have a form that "look for all patients with this procedure code" and I enter the number I am looking for. How can I merge all 13 fields into a single field?

It worked!! thank you very much now I have 8 more to do so I will try and copy what you have given me to get it all working thank you

sorry this is exactly what I now have Expr1: IIf([3 laboratory values]![preop sodium]<135 Or [3 laboratory values]![preop sodium]>145,[3 laboratory values]![preop sodium],"-") and I still get the "#error" in the column This is just not cooperating. How do I add [preop sodium] to the query?

thanks I changed it to IIF (it comes out IIf) the error message is gone but in the query results it says ERROR and no data at all in the column. this is exactly what I have Expr1: IIf([preop sodium]<135 Or [preop sodium]>145,[preop sodium],"-") what am I doing wrong ?

It is saying "undefined if in expression"

I am trying to write a double statement in the criteria of my query. If the sodium level is <135 or >145 then print the value, but if it is between 135-145 print "-". How do I say this ??