Originally Posted by
rpeare
i you just need a unique list of values just create an aggregate query, I would recommend staying away from reserved words like name, time and date but if you are stuck with those column names you could do something like:
SELECT [TableName]![Name], [TableName]![Time], [TableName]![Date] FROM TableName GROUP BY [TableName]![Name], [TableName]![Time], [TableName]![Date]
If you are looking to append your data again and only keep unique values, then the easiest thing may be to create an index/primary key based on all three fields. You'll have to dump your current data and re-import, you should get a notification saying how many records were NOT added due to key violations and you should be left with non duplicated items.