Query using multiple tables

  • Thread starter Thread starter steveWinder
  • Start date Start date
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!
 
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.
 
Back
Top