Cross checking data

[Guest]

Hi,
I was wondering if anybody has any suggestions for how data can be cross
checked using the reports.Any ideas for coding.
I would also like to know how to attach data from input via MS ACCESS forms
can be attached to a report.My email address is (e-mail address removed) and I
would really appreciate any help or you can reply on the forum itself.

 

[Duane Hookom]

Do have any suggestions for what you mean by "data can be cross checked"?

Forms can be bound to tables and reports can be bound to tables.

 

[Guest]

Sorry I got back late yes I was abit vague on the cross checking of data but
I would like to produce a report that displays duplicate records for the same
table that has data being inputed.Are there ways this can be done say using
Visual Basic and/or SQL.

 

[Duane Hookom]

"duplicate records" suggests this is a query issue. You need to create a
query that identifies duplicates based on some criteria that only you know
against a table and structure that you know.

Once you have this defined, create your report. There may even be a "find
duplicates" query wizard.