Simple SQL query help

  • Thread starter Thread starter Raz
  • Start date Start date
R

Raz

I have a table with the following columns: ContactID, Year and Status.
I need to write a query which will take the following records:
ContactID = 'XXXX', Year = '2003' and Status = 'Member' an duplicate
them while upgrading the year to '2004'.

I have tried to use the INSERT INTO command but as yet have failed to
achieve what I am after. Any help would be appreciated.
 
I have a table with the following columns: ContactID, Year and Status.
I need to write a query which will take the following records:
ContactID = 'XXXX', Year = '2003' and Status = 'Member' an duplicate
them while upgrading the year to '2004'.

I have tried to use the INSERT INTO command but as yet have failed to
achieve what I am after. Any help would be appreciated.
Click to expand...

Please post the SQL view of the query that's not working, and describe
what it's doing (or not doing).
 
Back
Top