From: excelCPA on 12 Nov 2009 12:26
On Nov 12, 12:14 pm, Jerry Whittle
> 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))
Prev: Inverted Query
Next: how do i not count weekend days in an access querry