Prev: Inverted Query
Next: how do i not count weekend days in an access querry
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