Sort joined tables

[anniez]

My record ID is a number. In a query, it sorts fine (1,2,3,4,5...) until I add another table to the query. Then it sorts as though it's a character (1,10,11,,,2,20,21...) I need the data from both tables and I need it in record ID order. Help...

 

[Trendsetter]

I can't emulate the problem.......

Are you sure that you are sorting on the ID from the base table not the added table???

 

[anniez]

Yes, I'm sure.
Table A: ID(N), empid(C), fieldx
Table B: empid(C), name, fieldz
A query of tableA can be sorted ok - number order.
When I relate the other table on empid, it sorts as though the field is characters.

 

[Trendsetter]

I've used a number of different table combinations from my own systems and cannot get the problem to appear...

sorry I can't help!!!

 

[cmmrfrds]

Show your query.

 

[anniez]

My tables are in Oracle - linked in access. That's what's causing it, right? Sorry. Can anyone help with that?