Hi

What i need help on is as follows

I have 2 tables.


1. live
2. backup of live

I run a query that downloads a csv file and stores it locally on the server. Before the latest information is copied into the live table i run a query to delete the records of the backup.

Once the backup is complete another query deletes the live records before the update happens from the csv file.

What i want to do is before the live table is deleted to do a check that the copy from live to backup was succesful. I do not use a primary key.

The data in the csv file is exported from a Telecoms switch, hence to ensure that both tables match It would be easier to validate with the number of rows in both tables.

I am very new to access. created my first database, but want to do a check between the two tables

would apperciate some help

many thanks

Asad