Group: microsoft.public.access.queries · Group Profile · Search for Archdat in microsoft.public.access.queries
Author: Sarah
Date: Sep 11, 2007 05:28
Better than having duplicate tables, queries, forms, and reports for archived data just add an Archived Yes/No field and ArchDate field to the table. Then have criteria in queries for Archived - No (Criteria will be the numerial zero.). That way the data is available if needed. -- KARL DEWEY Build a little - Test a little "Sarah" wrote: I have a database that holds information
|