Confirm

OK, in the absence of any feedback we'll leave things as they are. ------------------------------ John Gomersall ------------------------------

Hi Rebecca, Try this example: SELECT central_enquiry.enquiry_number, central_enquiry.enquiry_desc, central_enquiry.enquiry_time, central_enquiry.commit_log_number, enquiry_commitment.commit_log_time, enquiry_commitment.commit_target_time, ...

Hi Rebecca, Do you need those commitments that have already been met in your report output? If you don't you could put that IS NULL statement in the WHERE statement after any joins. If you need those that have been completed, then the simplest way may ...