Query to move data

[Guest]

Small example of my table

product id date Version nbr etc etc etc

2111 5/10/05 5.0
2112 5/10/05 5.0
2113 5/13/05 6.0
2113 5/23/06 6.0
2114 3/11/04 1.0
2115 etc etc

I want to run and append query that will only move the data that has changed
for a paticular Product ID number. My thoughts are an Append query but how
would I set up my criteria to move only the fields that have changed? Thank
you

 

[Guest]

Try this --
SELECT [Troy_s table].[Product ID], Max([Troy_s table].Update) AS
MaxOfUpdate, [Troy_s table].[Version Nbr], [Troy_s table].etc
FROM [Troy_s table]
GROUP BY [Troy_s table].[Product ID], [Troy_s table].[Version Nbr], [Troy_s
table].etc;