H
hughess7
Each month we get an updated table from our customers of names and addresses
etc which we link to our access database. Our customers would like us to
produce a report to show any change of address etc, or any new dealers,
compared to the previous months data. I have done two queries, one using the
unmatched wizard to produce the new dealers and another for any changes. The
2nd query checks for changes by using criteria <> previousTable.sameField (I
have added in the new and old table, linked on ID and put this criteria
against all fields to check for changes). It does work but there are a few
problems with it:
I have put the criteria for each field in the OR cell (ie stepping down a
row each time) because it can be any one of them that has changed. The first
problem lies in that there are not enough rows in the query grid, do I just
amend the sql manually for the other fields to check?
Secondly, this statement works if the field has different data APART from if
one of them contains no data, ie Is Null - this is then not selected. Is
there a way to trap this?
Thirdly, once I have the data in a query is there a way of highlighting the
fields/data that has changed in a record maybe in a different colour for the
changed text?
Thanks in advance for any help.
Sue
etc which we link to our access database. Our customers would like us to
produce a report to show any change of address etc, or any new dealers,
compared to the previous months data. I have done two queries, one using the
unmatched wizard to produce the new dealers and another for any changes. The
2nd query checks for changes by using criteria <> previousTable.sameField (I
have added in the new and old table, linked on ID and put this criteria
against all fields to check for changes). It does work but there are a few
problems with it:
I have put the criteria for each field in the OR cell (ie stepping down a
row each time) because it can be any one of them that has changed. The first
problem lies in that there are not enough rows in the query grid, do I just
amend the sql manually for the other fields to check?
Secondly, this statement works if the field has different data APART from if
one of them contains no data, ie Is Null - this is then not selected. Is
there a way to trap this?
Thirdly, once I have the data in a query is there a way of highlighting the
fields/data that has changed in a record maybe in a different colour for the
changed text?
Thanks in advance for any help.
Sue