Comparing copied tables

[sashav133]

I have to copy a linked table, and then check the two tables for a count of records to see if it has copied correctly. How do I do this?
I have to do it this way because the make table query changes the data type on one of the fields, which later on results in an error when the macro is run... And this operation will have to be done on a regular basis...

Thanks in advance...

 

[PHV]

In VBA you may use the DCount function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244