true false

[DENISE0714]

My customer database has a true false field which i use for current and former customers.  I use -1 value to pull only the true current customers.  I would like to be able to have two more tables instead of one but I am not sure how to do this.  I like to have the main table for both current and former.  Is there a way to have two other tables one for current and one for former that would update info on its own using the org table with both current and former customers.

 

[samara]

I'd like to use two query instead of two other tables, the first Query for current and the other for former just as you said. Of course you can do that by using query criteria.<br><br>Hope this would help YOU... <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[DENISE0714]

Thank you so much I did email you but I understand now.&nbsp;&nbsp;Thanks thanks thanks a bunch.<br>denise

 

[advpay]

Do a file save as on your customer table and name it something like CustomerArchive then go into CustomerArchive and select all the record and delete them all. <br><br>Now do an append query to this table where your true/false field = N or 0 ... this will put all the old one in the new table.<br><br>Now do a delete query on your main table...where your true/false filed = N<br><br>Now put both these queries into a macro and you can run it at your leasure to clean up your main customer table.