Hi, I need a query to pull back all entries in my database within a set date range who have no date for their first contact.

The problem I have is when you enter a referral in the form it creates an ID, then when you enter a contact in the form it create an ID in the tables.

I can pull out all fields with no contact date if they have an ID, but they will only get an ID if another field within the contacts form is entered (eg. a tick box or drop down).

If I do not enter anything into the contacts form, how can I pull back all patientID's who have a referral date and then pull back ones who have yet to have a contact date entered?

Can I search for a referral date but also blank field in contact date?

Is Null will not work as currently if they have no contact date then they are unlikely to have a contactID.

Does this make sense?

Thanks
Will