please help with checking data

  • Thread starter Thread starter steviegoodrich
  • Start date Start date
S

steviegoodrich

We have a database with 1000 records. we never add or delete records, only
amend them. Every month we need to check the data with a building management
system to make sure they are both the same,
we do a printout from a query for all records and manually check them.

Is there a way to printout only the records that have been amended in a
given month.

The database is used by 20 different people on a network. There are
probably 20 or 30 records that have been amended and we have to check all
1000 at the moment

using access 97 with limited experience (no experience with vb)

Thanks in advance for any help

Steve Goodrich
 
It is possible to add a "DateLastUpdated" Field in your Table and if *all*
users amend data through Forms and *never* the DatasheetView of the Table,
you can used VBA code to update this Field automatically.

You can then use Query to select only Records that has the DateLastUpdated
values that fall within the last month.
 
You can do a comparison of two data sources with an unmatched query. At the
database window and the queries tab, go to New and one of the options you will
see there is a wizard for building the unmatched query. The query returns all
the records in data source 1 that are not in data source 2.
 
Back
Top