Disappearing Data

[Jeff@Tufts]

I'm having data disappear on me. Users will enter data in a form and then
run a report. Several days later after entering more data and running
additional reports and then cross checking the reports only to find that data
the was entered has disappeared. PLEASE HELP!

 

[Jeff Boyce]

Jeff

"Disappeared" ... from the reports? Or from the underlying tables?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff@Tufts]

I don't know. The missing data has been re-entered....

 

[Jeff@Tufts]

I don't know. The data has been re-enter.

Jeff

"Disappeared" ... from the reports? Or from the underlying tables?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

If the data was 're-entered' into the same table(s) it was originally in,
and if the data actually never left those tables, but simply didn't appear
in the reports, then you'll have "duplicate data" in the table(s).

This is something you can check for.

(by the way, in several newsgroup postings in the past on the topic of
disappearing data, the eventual cause has turned out to be inadvertent
deletion by well-intentioned but poorly-trained users ... after all, who
would want to admit to having killed the data?!)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff@Tufts]

Thank you.

If the data was 're-entered' into the same table(s) it was originally in,
and if the data actually never left those tables, but simply didn't appear
in the reports, then you'll have "duplicate data" in the table(s).

This is something you can check for.

(by the way, in several newsgroup postings in the past on the topic of
disappearing data, the eventual cause has turned out to be inadvertent
deletion by well-intentioned but poorly-trained users ... after all, who
would want to admit to having killed the data?!)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP