Access text field number comparison

[nalmond]

I have a query that attempts to identify differences between current and previous versions of a data set. A linked text file is compared to a static table within access using a query that is joined on a unique ID field.

The problem is that for text fields that contain numbers as text the following OR criteria does not function. Any differences between the contents of the field that are text, eg EUR_GCCA, are identified but any that are numbers , eg 1234, are not and are found missing from the query results.
Here's an example of how the expression looks:

[TPM_NodeExtract]![Contract ID]<>[Previous_TPM_NodeExtract]![Contract ID]

Is there a more suitable operator than '<>'? Or am I completely off the mark!

 

[traingamer]

Just convert your string values to numeric with CDbl or CInt or whatever. (Or convert the numbers to strings.) e.g.

[TPM_NodeExtract]![Contract ID] <> CInt([Previous_TPM_NodeExtract]![Contract ID])

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill