comparing data

[Guest]

I want to double check my data entry. I created a query, Column A contains
sums of records, Col. B contains amounts. I want to compare these two
numbers, row by row. In Column C I would like to have some kind of response
to alert me if they are not equal. Or have the response alert on a report.
How should I go about getting these results?
Thanks for your help.

 

[Guest]

I do not quite follow what you are proposing but you can add a Validated
(Yes/No) to your table. Have a temp table that has the same structure except
for the validation field.
Type your entries. Then using the temp table load the data again. Run an
update query to set the Validated field on all records that match. Run a
query for all records that do not have a validation. Correct errors as
necessary. Empty the temp table.

 

[Guest]

For maximum visual impact a report might be the best solution. Create a
simple report based on your query and in the detail section add a label with
whatever caption you want as your alert. You can make it as big, bold and
brightly coloured as you wish.

In the Format event procedure of the detail section hide or show the label
depending on whether the values of the columns are equal:

Me.[YourLabel].Visible = ([Column A] <> [Column B])

where YourLabel is the Name property of the label.

Another possibility would be to base a continuous form on the query and use
Conditional Formatting to change the colour of a control if the two values
are not equal.

Ken Sheridan
Stafford, England