Re: Previous Year
From: Tim Ferguson (FergusonTG_at_softhome.net)
Date: 03/18/05
- Next message: Tim Ferguson: "Re: Trying to delete tables, forms, queries, etc. in an external datab"
- Previous message: Tim Ferguson: "Re: Previous Year"
- In reply to: scuba79: "Previous Year"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 18 Mar 2005 09:14:32 -0800
"=?Utf-8?B?c2N1YmE3OQ==?=" <scuba79@discussions.microsoft.com> wrote in
news:0FEF2BAC-4E58-4CF7-987B-D6B3F53993A2@microsoft.com:
> I have a client that is using Access 97, they want to be able to
> archive some records, however, I need to make sure that the records
> that they are archiving are not from the previous year and I need to
> code it so that it will be automatic for each year...
Archiving records is fine: the best way is to create a field called
"Archived" and set it to true for the records that have been archived.
Or, if you prefer, you could use a DateTime field and set it to the date
the thing was archived.
You can look at your historic records with a query like "WHERE
Archived=TRUE" or even "WHERE ArchiveDate IS NOT NULL"; and active
records with an opposite criterion. And when you want to combine old ones
and new ones, you don't have to mess about with all this nasty UNION ALL
stuff.
There is no reason to create extra tables when you don't need them; and
it's always asking for trouble to store data in table names.
HTH
Tim F
- Next message: Tim Ferguson: "Re: Trying to delete tables, forms, queries, etc. in an external datab"
- Previous message: Tim Ferguson: "Re: Previous Year"
- In reply to: scuba79: "Previous Year"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
