I am new to Access and have one small problem I can't seem to solve. I have
a database with multiple order records for people. Each person has a unique
ID, and is on the datbase multiple times, but only one of each record has
the address, and phone, etc. I need to copy the data from that record into
all records with the same IDs.

I know I can creat multiple tables, but I need it in a single table so it
can be exported to a mailing/accounting program.

Any ideas would be appreciated.

LarryH

You will need to create 3 queries.
qryHasAddr
will return only those records with address, etc. Use: not is null
as the criteria

qryNoAddr
returns all other records. Use: is null

as the criteria.

Here is the fun one.
Create an update query using the the 2 queries above linked by ID.
Then pick the Addr field from qryNoAddr.
in the Updateto box put:
[qryHasAddr]![addr]

do the same for all the fields and run it.

I would make a backup copy of the table just in case!!!

If this makes no sense send me an e-mail and I'll send you a sample.

Good Luck
Ira Solomon



On Thu, 1 Jan 2004 15:05:56 -0700, "LarryH" <lhusband1 (AT) cox (DOT) net> wrote: