"Make Table" Query : Do Not Allow Duplicates

[dvent]

Hi All,

I have a "Make Table" query. I want to ensure that the table that is produced does not have duplicates in the first field i.e. Indexed: Yes (No Duplicates).

Can this be done?

Thanks
dvent

 

[JamesMcS]

What's in the rest of the query? If you 'group by' the first field, it should get rid of dupes - assuming that's the only group by in your table.

to set primary keys in a table you have to create a data definition query (or just go into the table design but that's cheating).

 

[dvent]

Ah! I had more than 1 group.

Change to just one group and that's fixed it.

 

[JamesMcS]

So simple... yet so annoying... have a good weekend!