How do I fix this?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

whitjl143 - 30 Apr 2005 17:20 GMT

I have a table with Name, Date, Description fields. This table has 11,000
records in it. I now know that I need to have the Name and Date fields in a
table and the Description field in a separate table. Then I would use forms
and ID fields to link the information.

The following is an example of what is in the table:

Name Date Description
John Doe 3/27/05 Zone 1
John Doe 3/27/05 Zone 2
James Bond 3/27/05 Zone 5
James Bond 3/28/05 Zone 1

I don't know how to take the data and manipulate except by manually deleting
the duplicate names and dates and adding an autonumber field to get Table
one. And then manually entering the number to match the autonumber field in
the Description table. I am afraid that if I do this, I will mess up the
data and it won't be accurate anymore.

Any help out there?

Thanks!

Signature

Jenn

Reply to this Message

Jeff Boyce - 01 May 2005 13:21 GMT

Jenn

First, consider renaming your fields -- I believe Access uses all three of
those words as "reserved". Continuing to refer to "Name" and "Date" will
only confuse both you and Access.

Why do you believe you need to keep YourDescription in a separate table?
From your example data, it may be that you need TWO additional tables (one
for valid Zones, and one for valid PersonZone combinations).

You can use Append queries to fill in records in new tables.

Signature

Good luck

Jeff Boyce
<Access MVP>

> I have a table with Name, Date, Description fields. This table has 11,000
> records in it. I now know that I need to have the Name and Date fields in a
[quoted text clipped - 18 lines]
>
> Thanks!

Reply to this Message