How to create reports that include empty fields

  • Thread starter Thread starter Werner Sieg
  • Start date Start date
W

Werner Sieg

I am working with a relational database and am creating a
report from several tables, using the design wizard. The
report looks something like this:

book title, author, publisher.


Each book title has a product id. The authors are listed
in a separate table but are linked by the product id, as
is the publisher. The problem is, if I want to print the
list, if a book title does not have an author or publisher
in the author or publisher table, it does not show up on
the report. How can I make a complete list of titles with
author and title, including those titles with no publisher
or author in theauthor and publisher table. Thank you for
any help.
 
Try a left join, something like:

SELECT [Product table].[book title], [author or publisher table].author,
[author or publisher table].publisher
FROM [Product table] LEFT JOIN [author or publisher table] ON [Product
table].ProductID = [author or publisher table].ProductID;

HTH
Mich
 
You can set this up in your query. Double-click the join lines and select
the appropriate join option.
 
Back
Top