From: excelCPA on 12 Nov 2009 12:26 On Nov 12, 12:14 pm, Jerry Whittle <JerryWhit...(a)discussions.microsoft.com> wrote: > Unless it's just a typo below, you have Tables2 and Table2 in your SQL. That > little s could make all the difference. > -- > Jerry Whittle, Microsoft Access MVP > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > > > > "excelCPA" wrote: > > I am attempting to have a query from two separate linked tables. Both > > fields I am trying to join are all numbers, however Table1 has this > > stored as Number, the other has this stored as Text. I can't change > > the properties of the linked tables since I don't own them. > > > I tried converting the tables stored as text in the join as follows > > with no luck: > > ([Table1] INNER JOIN Tables2 ON [Table1].Policy_Number = val > > (Table2.PolicyNum)) > > > Any ideas on how to join these tables in the query? Thanks. > > .- Hide quoted text - > > - Show quoted text - That is a typo. the SQL is ([Table1] INNER JOIN Table2 ON [Table1].Policy_Number = val(Table2.PolicyNum))
|
Pages: 1 Prev: Inverted Query Next: how do i not count weekend days in an access querry |