i have access 97. i would like to take the date received field (everything received from 01/01/1997 to 12/31/1999) and make it a separate one with a new name.

1. Create a new empty db.
2. Import the table description (but NO data) from the old db.
3. Open the old db and link to the table in the new db.
4. Create an append query that selects rows from the old table with DateReceived < 1/1/2000 and appends them to the linked table.
5. Create a delete query that deletes rows from the old table with DateReceived < 1/1/2000.
6. Compact the old db to recover the space used by the deleted records.