Hi,

I am trying to append a small table to a master table. The small table
contains patient demographic data (name, address, birthday, etc.) and
multiple dates of service (Date 1, Date 2, etc.) for each patient.

I would like to append the small table to the master table sorted by date
of service so that the patient's demographic data is also appended to the
master table for each date of service.

I have tried an append query with a "group by" criterion but the results are
not what I desire.

Any help is greatly appreciated.

Brock Fisher
San Diego