Reports - not including new entries

[Cathy]

I presently have an Access 2003 formatted database opened with Access 2007.
Users are entering and editing information, via forms, directly on tables.
These tables are then the basis for reports.

We are running into a problem with the timing of the reports. It is
catching values that are in the middle of being entered or edited and
throwing off report totals. Is there a way for Access to only include items
on the reports that are not being entered or edited at the moment the report
is being run?

I understand one solution is to add temp tables and have the new entries and
modifications occuring on the temp table, while the reports are going against
the main table. Is there another solution?

 

[Wayne-I-M]

There are few methods but possible the simplest (and so less likely to go
wrong) would be to add another field to the table - say
ThisRecordIsNowComplete

When a user has finished a form filling in they click a button and the
ThisRecordIsNowComplete is filled with something ?? (could be a tick, a A or
B or C, etc) anything will do.


Don't work from the tables but create a query based on the table to run the
reports.

Only run reports that have the "something" in the ThisRecordIsNowComplete
field

Oh the ThisRecordIsNowComplete can be filled not only a button Click but
also if the form is filled in right or any other criteria you (the
application builder) sets.

Dead simple