If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Master detail report
I am trying to figure out how to show all rows from a master table even if
the detail table does not have records for some rows. |
#2
|
|||
|
|||
Master detail report
Lydia,
You left out quite a bit of detail, but I'm guessing that you are trying to build either a query or report from a master and detail table. When you join the two tables, you want do a Left Join where you include all records from the master table and only those records from the detail table where the joined fields are equal". You need to build a query and join the two tables. The SQL should look like: SELECT tblClass.ClassNo, tblLookUpD.LongDesc FROM tblClass LEFT JOIN tblLookUpD ON tblClass.ClassName = tblLookUpD.CodeKey; Good luck, Dennis |
#3
|
|||
|
|||
Master detail report
This is basically a query question. Use a LEFT or RIGHT JOIN that includes
all the records from the Master table. -- Duane Hookom MS Access MVP "Lydia" wrote in message ... I am trying to figure out how to show all rows from a master table even if the detail table does not have records for some rows. |
Thread Tools | |
Display Modes | |
|
|