Many thanks for your reply...putting both 'WHERE' clauses worked (strange they didn't work when I was trying my combinations - possibly blind panic and stress mixed in).

As your 'id' question - I am not using one because the call runs through the 'collegetotalpay' column looking for a 'Yes', if there are any then it writes in the 'collegetotalpaid' field 'Yes' (then a date) and the finance run proceeds on all of those records.

Hence, I am looking for all records not one specific invoice.

Thanks again for your help - onwards now to the asp part and setting values in parameters for the stored procedure to collect.

Does this EVER get easier because I honestly feel like changing professions!!