Appending to a table

[superrob5]

I wanted to know how to make a query that will take a specific field and append it to a new table. But it has to be unique. If a word is repeated it should only show up once.


What I am trying to do is make the tabe have a relationship instead of having a repeated field.


Thanks

 

[dcx693]

Use a regular append query. You should structure the table to be appended to so that the field in question will not accept duplicates.

 

[superrob5]

oh ok. yeah access gives me back an error message not able to append the duplicated record.

For instance
Open
Open

the second open would come up with the error

 

[Pat Hartman]

Select YourField From
YourTable
Into YourNewTable
Group by YourField;