stuck

[F17RUK]

Hi Guys



I need your help with some code on how to build this query

I have a excel spreadsheet list of Tag numbers unique - which have a about 6 attributes (data) i.e description, operational/Void, etc

This list is being updated every day. Attributes are being updated and tags are also been added and made void. I need it to show me where things have changed since the last run of the report

The report is run every two weeks and i need to show:

Tags which have been added (new) since last run
Tags which have been deleted (made void in list) since the last run

Tags which may have had an attribute updated with a value since last load,

* showing- Tag/Attribute changed/Old Value/new Value

I am planning to put this excell sheet into Access starting with a baseline report today, and then loading the run in two weeks but giving it a date stamp and appending it to the table, from here i am stuck??

regards

farooq

[alansidman]

I would not append it to the old table until after you have had a chance to run a query to show differences. With each upload, run an unmatched query (using the wizard) to show items that were present and have come off the report. Run an unmatch query to show items that have been added since the last report. You could then run queries where the record exists in both files and do not have matching attributes. You will not have one query, but several as you are testing for different issues.

Here is a good starting point on building queries.

http://www.techonthenet.com/access/queries/index.php

Alan