I'm sorry I misunderstood your ?. No I did not execute that string exactly. I will try that.

But I do know in access when I tried to remove @MedRecNum and just put the value in it gave an error stating the variable needed to be filled in. I will try your suggestion in the qry analyzer.

Tracy Ramirez