Query using multiple tables

S

steveWinder

I am trying to create a query using 3 separate tables that
are related by a common field.(Was created in Office97 and
converted to Office2000.) Running a query with each
individual table works fine but together no data is
returned at all. help!
 
A

Andre

I had the same problem a few days ago.

Be sure that all the field are the same type and size.

If join fields are Number, but on one of the tables is
size Long and on the other is size Decimal, the join will
not result.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Consolidation Table from Different Excel Tabs with Different Format 1
Page numbering with Merged Document and IF statements 1
QBF & Query Malfunction 0
Some mail merge fields not pulling into document 2
Embed the same Excel multiple times 0
DLookup in Continuous form 0
query to show where no data in a stated column 0

Top