How to append every nth record?

[azgambit]

I'm looking for a really simple way to do this and I didn't see anything through my searches of the forums. So, here goes (if I missed a post covering this, please don't kill me

I have db with two tables (Action and Archive). The Action table has over 1500 records, but the records come in batches of 4 identical records. For example, record 1-4 are the same, 5-8 are the same, and so forth. Each record has only one field, a text field.

What I need to do is find an automated way to append or copy every fourth record from the Action table to the Archive table.

I really don't want to have to do this by hand. I'm thinking an append query is the way to go, but if it is, I'm not sure how to configure the parameters.

Any suggestions would be appreciated!!

Thanks all!!!!!

 

[pono1]

This might be worth a try... Before trying this be sure to backup your table and then make a backup of your backup. (You could also -- less simple -- write code to do it -- looping through the recordset in steps of four.)

Regards,
Tim

 

[azgambit]

It worked

I guess what it took was a shift in thinking. I'm fairly certain I can write some basic code to do this with a command button.

Thanks for the idea, it worked and it got me started.

Thanks!!!!!!!!!!!!

 

[neileg]

Why not just use a unique values query? This will ignore all repeats of identical records.