SueB - I appreciate your apology but I felt pretty bad when I looked again at my contribution, which in retrospect I agree was completely unhelpful. One lives and learns ...

sueb - I had a quick look at the database. It really needs to be normalised into separate tables. By putting so much into the IUR table you are making it difficult to manage and not gaining the benefits of a relational database. For example there is no need to hard wire a maximum number of three telephone calls against each patient. Make telephone calls a separate table and link them to patients via the unique patient ID. Also, if you ever want to...

Are you using unbound forms (not linked to a particular table or query)? Also, will the data from Form A become a record on its own in the target table, or is the data from Form A to be combined with Form B/Form C before adding to the target table?

This article results from a problem I encountered in an Access database.

SQL assumes that dates are in US format: MM/DD/YYYY. Suppose that a date is entered into a MS Access form and then used in an underlying SQL query. If the date is in UK format DD/MM/YYYY then unpredictable results can occur because Access attempts to interpret the date as if it were in US format. If a valid date results then the procedure proceeds with an altered...