Append Query

[Guest]

hello guys,

I created an append query for a table with multiply fields and the records
within each field can duplicate themselves. How can I develop a unique field
from four of my major fields to correct this problem? I have one field if
put together with the others could function as my unique identifier.

 

[Guest]

Add a separate auto-number column for your primary key.

-Dorian

 

[Guest]

it would not work because the other tables aren't set-up like that.

 

[Guest]

Hi,

If you "have one field if put together with the others could function as my
unique identifier" then you have the necessary information to create a
composite primary key across the four/five fields.

Open your table in design view, select the fields and click the Key on the
toolbar.

Hope this helps.

Damian.

 

[Guest]

thanks guys, but what i'm thinking about is creating a new field that
composite of the four other fields. however, i'm getting a syntax message,
please help?

examaple: Id: =[ss#]+[DOB]+[ZIPCODE]

 

[Guest]

Hi again,

Do you have data in each of those three fields? Are they all the same type
(text). Try formatting them first, like this:

ID: cstr([ss#]) & format([DOB], "ddmmyyyy") & [ZIPCODE]

Damian.

thanks guys, but what i'm thinking about is creating a new field that
composite of the four other fields. however, i'm getting a syntax message,
please help?

examaple: Id: =[ss#]+[DOB]+[ZIPCODE]

Hi,

If you "have one field if put together with the others could function as my
unique identifier" then you have the necessary information to create a
composite primary key across the four/five fields.

Open your table in design view, select the fields and click the Key on the
toolbar.

Hope this helps.

Damian.