I am (still) working with Access 2002/2000. Working on my WineCellar Database, I am having a problem with reports based on a query. Basicly it’s a report of all the wines I have tasted. I managed too sort the data the way I want using the sorting order in the report. There are a few minor items, but for now I ignore the fact that the form shows on the first page only the header. I discovered that I had to have the ID field in the query as well as the name field to show data from a related table. Question: Now I am missing some wines in the report that are in fact in the table. Problem not all the fields of those wines are filled. Champaign has not always a year on the bottle so that I have to leave out. But now those and the wines with incomplete date don’t show up in the report. I looked again into classes 101 and 102 and saw that the Customers with a missing State still are on the report. How to handle this problem? I made a query just for the Champaign’s without the year field, but that is not what I want for there are Champaign’s with a year and it is good to know which one.
Thanks eddy
Reply from Richard Rost:
You mention showing records from a related table, but we haven't gotten to that yet in Access 103. I don't cover relationships and multiple tables in a query until Access 201. So if you're missing records from one or more of your tables, it could be because you're using an INNER JOIN instead of an OUTER JOIN.
For example, if you have CustomerT and ContactT and you join them together on CustomerID with an INNER JOIN (the simplest type) then you won't see any customers who have zero contacts - and vice versa. You need to use an OUTER join for this, which I cover in Access 220.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.