Cast or reg expression in where clause

[Denis Dougall]

I have two (one Oracle linked other Access 2002) tables A & B. Table A has a
column called "XREF" of text type with values like 25.5 decimal / real
numbers and Table B has two integer columns with values like 25 and 5 which
are the Primary key. My question is in a where clause I want to cast the
Table A column "XREF" to two integers (like 25 & 5) and make a distinct row
or inner join or union with the two int values as the primary key in Table
B. Any suggestions?

Or

use a regular expression similar to a VB mid type filter.

Thanks in advance,

Denis



Sample data

Table A

Autonumber(PK) Xref ........
4000 25.5 .........

Table B

Number1 Number2 ..........
25 5
| |
|___________|
PK

 

[David S via AccessMonster.com]

My suggestion would be to create a query that uses the linked table A which
creates the two columns from the XREF. The formulae for the two new columns
would be Int ([XREF]) and ([XREF] - Int([XREF])) * 10 (or whatever number of
decimal places you have)...

 

[Denis Dougall]

Thanks! You pointed me in the right direction.
Cheers,
Denis