Grouping table values but keeping original field name?

[chuckles1066]

I will explain.......

I have an automated procedure that appends records to a master table. This happens every night.

The records won't change for maybe three months at a time.

So what this means is that I'm appending the same 1,200 records every night for 90-odd days at a time. Then the records will change and the append now starts adding the new records.

How do I extract the unique records into another table?

In SQL I'd use DISTINCT.

I know I can use the GROUP BY / SUM / COUNT functions in Access but this then means my new table has headings like SumOfInvoices, CountOfProducts etc.



How do I consolidate all of the records AND keep the original field names?

TIA.

[JoeM]

In SQL I'd use DISTINCT.

You can use it in Access too. After you create your query, just switch to SQL view, and add the word "DISTINCT" after "SELECT".

[chuckles1066]

Ahhh, thank you very much :-)