I want to do something that WAS easy in my former world (a dBase environment) but I can't figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone's help.
This is what I want to do, in order:
1) Select the top # records of a table, "#" is a field in another table.
2)Replace a field in the table with a value for just those selected records.
3) Append all the records with that value to another table.
4) Delete all the records in the original table with the value I put in.
If I were working in the dbase world, it would go something like this...
replace next 200 (or whatever number) receivedate with #1/1/2009#
Append from table1 for receivedate<>0
delete all from table1 for recievedate<>0
Sounds so simple, but I don't know how to do it in SQL Server or Access.