Re: There must be an easy way to do this...

#1

1. It sounds like you have may want to normalize your data into two
different tables
a table for patient info
and a table for services performed

2. The order of data in a table should not be an issue, a query should
solve any data organization problems

3. you can always create a new table with the data properly merged and
ordered then get rid of the old unsorted data. I often do this in SQL
Server to merge data from related tables in the format I want to view.

Hope this helps

"Brock" <brockfisher(remove this)@cox.net> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: There must be an easy way to do this...

comp.database.ms-access comp.database.ms-access

Re: There must be an easy way to do this... - 07-23-2003 , 12:39 PM