separating "dead" files without deleting 2

[deana7732]

I am very very new to Access, and have no idea how to write code. If I am in an Access 97 table, and I need to remove customer data for accounts that are "dead" (paid off), is there a way to separate that information and remove it from the table without deleting it altogether? I still need it for stats and contact information.
I am so confused.

Thanks!

Deana

 

[humbleprogrammer]

You can add a status field to your table and input &quot;paid off&quot; into the status for all the dead records. This would keep the data intact but allow you to report of all records that are <> to &quot;paid off&quot; or show only records = to &quot;paid off&quot;.

 

[LittleSmudge]

And to extend the idea but keep the memory size used to a minimum :-

Call the Status field &quot;PaidOff&quot;
Make it of type Yes/No
Default Value No
And set it to Yes when the record is paid-off.

This way you use ONE byte per record for the function instead of 16 and your queries will be easier to write too.


'ope-that-'elps.

G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[deana7732]

After weeks of fighting with this database, I got it back to the point that I could actually implement your ideas. Thank you so much, both of you!