Coping a single record from on table to another

[drobertson@adxusa.com]

Using Access 2010 I’m been trying to do a query to get a single record from one table to another. I’m to the point of just not doing it; can someone give me some help?

[ssanfu]

More info??

What have you tried? (SQL)
What are the two table structures? The same structure? (fields)
How do you select the record to copy?

[drobertson@adxusa.com]

Both tables have the same structure and field names. I have been on the Google looking at several different options and tried several of them without success.

[ssanfu]

OK.

Again:
What have you tried? Post the SQL of what you have tried.

How do you select the record to copy? In query design view, you will enter something to select only one record? If you don't have a way to limit records, instead of copying one record, you will copy ALL records.

Do you have any "look up fields" defined in your tables? If you do, this will be much, much harder.
---------------------------------------------

In general terms:

Create a new query.
In design view, add all of the fields you want to copy - but NOT an Autonumber field. (remember the warning about "look up fields")
In the menu, change the SELECT query type to an APPEND query type. Access should ask you what table to save the data in.
Select the table.
Execute the query.

That is the simplest way. But without more info, you will have to experiment.

[drobertson@adxusa.com]

Thanks Steve,

I'll need to get into the tables more but I think i understand what needs to be done. I'll let you know the result. I done a lookup to find the record but when I tried to move it in the past it moved all records what am i overlooking.

[ssanfu]

I done a lookup to find the record but when I tried to move it in the past it moved all records what am i overlooking.

A "Move" or a "Copy"??? these are two different things.

Without more info about your dB (table structure - the fields), any error messages and about what you have tried, I can't tell you WHY it doesn't work.

Its like me asking you "Why does my car squeak"?