Query Patient names and list appointments

[Melanie_H]

I have a table with the following fields:
Patient | Appt. Date | Time

Staff goes in and puts in the patient, apppointments and times.
Some patients are entered more than once as they have more than one appointment per week.
(The patient will be entered in a separate record for each separate appointment they have. **they want it done that way)

How can I create a query that will give me a list of a patient, with all of their appointment dates/times without each one being on a line.
I want to see:
patient name appt. date time | appt. date time | appt. date time

Where as I am seeing now:
patient name appt. date time
patient name appt. date time

Or..... should I be doing this in a report where it would list the patient and all corresponding appt. dates and times.
If so ..... how?

Thanks for any guidance.

Melanie

 

[Uncle Gizmo]

I did something similar a while back, there’s a sample database here that you may be able to adapt to your particular requirements.