Union / Pass through query help

[JT]

I posted last week that I was trying to combine data from
2 tables in order to generate reports on total dollars
recovered.

I was advised by more then one to utilize a union query in
order to query the data i needed.

I created a union query that looked like this:

select [actcat], [actprin], [actotal]
from colacct
union
select [actcat], [actprin], [actotal]
from colachis

When I ran this query I received the following error:

ODBC call failed [Microsoft] [ODBC Visual F(#200)]

So, I read up on the error at Microsoft Knowledge Base
Article - 244904

I was instructed to create a SQL pass-through query that
uses the Microsoft Visual FoxPro ODBC driver to perform
the union query

So I did. I run the pass-through query and dont pull any
data up. Just 3 expressions that all reflect the field
names not the data I'm trying to query. Did I miss a step
somewhere?

Jason
...

 

[Albert D. Kallal]

You mention that you are using FoxPro, and thus you might want to try some
of the FoxPro groups.

Are you trying to read FoxPro tables, or older dbase tables?

Access will in general read the older dbase formats, but it depends on if
you need to update them.

Do each of your quires to the FoxPro data tables work when run as separate,
non UNION queries?

 

[Guest]

I actively use access to run queries on these tables
(foxpro 3) with no problems. The 2 queries I wrote worked
fine except when I tried to combine the data with a
standard query. I was then instructed that a Union query
was the way to go.