Normal Data Sets when using Unmatched queries

[Allison]

Issue:

I tried to run an unmatched query on two different tables

The first table is a Linked ODBC table(from another
database).

Table # two is a MS Access table.
(Keep in mind both tables are from a make table query
since I can't alter linked data)

I tried to perform an unmatched query on the two tables
by Serial Number.

I found in one table the serial number of some records
begin with a zero

Example: 01833

In the other table some records don't begin with a zero

Example: 1833

In the above examples the correct number is 1833 is there
a way to make but tables appear the same prior to the
unmatched records query. Or can I put in a critiera in the
serial number to make all the numbers the same.

 

[Tom Ellison]

Dear Allison:

It looks like the column you're matching is a text column containing
only integers, and that you want to match them on the numeric value.
Does that sound right to you?

If you write a query that returns all the needed columns from the
table, but for the SerialNumber column return CInt(SerialNumber) AS
SerialInteger, then you can perform the unmatched query on this query
instead of the table that may have leading zeros. I think that would
help.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

Issue:

I tried to run an unmatched query on two different tables

The first table is a Linked ODBC table(from another
database).

Table # two is a MS Access table.
(Keep in mind both tables are from a make table query
since I can't alter linked data)