SIMPLE QUERY - BLANK RESULTS

[Guest]

running a simple query that includes 2 tables. All fields in both tables are
text. When I run the query, I get the data from the first table, column
headings from the second table, but no data from the second table. They are
blank. The 'Show' box in design view is checked, the correct number of rows
appears, but no data from the second table. I am at a loss.

 

[John Vinson]

running a simple query that includes 2 tables. All fields in both tables are
text. When I run the query, I get the data from the first table, column
headings from the second table, but no data from the second table. They are
blank. The 'Show' box in design view is checked, the correct number of rows
appears, but no data from the second table. I am at a loss.

Then there is something wrong with the query, or with the data in your
table, or with the joining fields.

Unfortunately we cannot see these from here.

Could you please post the SQL view of the query, and give an
indication of the data in the two tables which you would expect to see
and don't?

John W. Vinson[MVP]

 

[Harley Feldman]

Are the tables linked by any common field? If not, the query will likely
list only the fields from the first table. If the tables are linked with a
common field, then the default inner join will pull up records from both
tables that have a common value in the common field.

Harley