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