Search results

Thanks - Actually before I run any of the compare scripts I set any nulls to zeros in number columns and nulls equal to Null in string columns. Thanks again.

I have used AND in my scripts before without a problem, but decided to try removing the AND's anyway because I am trying everything. It worked! Removing the AND's worked. Thanks so much for your help JZWP22!!

I expect the variables strSource1, intspan1, strCCode1, strCCPSflg1 to be set equal to the corresponding database values. This then used as comparison to another record further on in my code. I have a number of scripts that use similar logic for data comparison in a data cleansing tool I am...

I am running the following VB script and keep getting a 'Runtime Error 13 - Type Mismatch'. The code is below. The type mismatch is occurring on intspan1 = ![span] ![span] is a number from the table. intspan1 is defined as a long integer. I have tried defining intspan1 as an integer, a...

Hello, I am a new member on the Access World Community. I have been using Access since Access 2.0 (on Windows 3.1) - so a long time. Nevertheless, it has been some time since I have actually developed anything in Access and I find reading through the forum a valuable exercise. :)