Unmatched Query not showing all fields for matching

[dustyteter]

Table 'A' is a link back to an Oracle table.
Table 'B' is an actual Access table.

both tables are the same in ALL ways other than the data elements in the ACCESS table identified as NUMBERS are showing a "field size" of LONG INTEGER while the number elements in the linked table are showing "field size" of DECIMAL. Obviously I can't modify the "field size" of the data elements in the linked tables.

When I try to run an unmatched query none of the fields from table A that have a field size of DECIMAL are showing up for me to use as matches to the other table..

anybody run across this before?

Thanks for any help/tips

 

[PHV]

You may tweak the generated SQL code playing with the CLng function.

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