Hi Faye, The second "AND" should be fine. I would ask if "user_dnumber" is a numeric field? You seem to be comparing it as a string. Try taking out the leading and trailing single quotes encompassing user_dnumber and see what happens. HTH, RonL. -----Original Message----- From: Faye Tarzwell (FayeC) [mailto:ftarzwell@fayec.com] "AND user_dnumber='" & dnumber & "' "