I have one table which has a patient's name, and another table which contains a record from each time a patient visited our clinic. Each visit record includes the date. The tables are joined via an ID number - the patient table is the "one", and the visit table is the "many". I need to write a report that will display only the patient names of those who have visited for the first time since a specified date (the specified date to be determined by a parameter).
Any ideas on the easiest way to do this?
Any ideas on the easiest way to do this?