design query result is blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I am using Access 2000. I have built a query with six tables. Whenever I
run the query, if no information is in two of the table’s particular fields,
the query result is blank. On the Join Properties table, number one is
selected for all the tables, which I believe is the Inner Join. I am seeking
a method to get the query result for the parameter even if no information is
in a particular field.
 
DG said:
Hello
I am using Access 2000. I have built a query with six tables. Whenever I
run the query, if no information is in two of the table’s particular fields,
the query result is blank. On the Join Properties table, number one is
selected for all the tables, which I believe is the Inner Join. I am seeking
a method to get the query result for the parameter even if no information is
in a particular field.
Click to expand...

You have to use LEFT or RIGHT JOIN and WHERE column_name IS NULL and the
"always show" columns in the SELECT clause. Best shown by changing your
SQL. Please post your query's SQL and tell which tables you always want
data on & tables/columns which may not have data.
 
Thank you very much for responding. I found helpful information within the
Discussion Group. You are correct, by utilizing the right join on the tables
that sometime contain information in a particular field, my query is working
as I intended.
 
Back
Top