Query to duplicate a record with one field updated

R

reef21

Joined
Mar 28, 2012
Messages
1
Reaction score
0
I have a database that stores job competitions and applicants. I have a table called Applicants. It has a primary key named AppID, a field called CompetitionID and other fields storing name, address etc. Applicants for job competitions have an AppID and a CompetitionID. Users would like to enter an existing AppID and insert a new record with the existing information duplicated but with a new CompetitionID.I need a query that can create a new record consisting of a copy of an existing record specified by the AppID the user enters in the Parameter, with the new record having a new sequential CompetitionID. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where do I Calculate Previous Record? 3
Help with getting average in a query? 1
Adding New Record to a linked table from Query 1
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
query: record count discrepancies 1
Updating a field in a new record added via bound form 1
Count text values in a Access Field 0
Append a record multiple times to a new table 1

Top