Transfering Old Records

[mateogp]

Hey All,

This may have been covered already, and if it was I appologize. Searched for it but couldnt find it.

Any how, I have a large table of records (problem is its growing). It lists customers and dates. My table has way to many records, so i need to condense it a little bit. What i need to do is transfer contracts that have been fulfilled (by date) transfer to another table that contains records of contracts that have been fulfilled. I want to do this by a push of a button, automatically transferring any records that the date has passed to the pastcontract table.

Any ideas? Im not quite sure how to proceed.


Mateo

 

[ghudson]

I doubt your table has "too" many records. You need to read up on "normalizing" your db. Your forms and reports should never be directly linked to a table, you need to use a query definition or SQL to populate the records [data source] to filter out only the records that the user needs for the form or report.

 

[djshongo]

i also have this same problem, id like to transfer all my "old" records to an "old records" table.

how do i do this?

thanks.

 

[ghudson]

i also have this same problem, id like to transfer all my "old" records to an "old records" table.

how do i do this?

thanks.

You need to read up on "normalizing" your db.

 

[mateogp]

I tried using a query to view records using <Now or however it goes. It worked, but due to being a live database it seemed to take more time than what would be considered acceptable.

Since im not an expert at Access, I dont know if its with in my knowledge to normalize a database. My company gave me a very low budget to do most of this, so I cant really go to outside help to often when it requires funding.

Mateo