Rod,
This sounds like you need a simple LEFT or RIGHT JOIN. Double-click the join line to open its properties. You can select 3 options, one of which will meet your needs.
Duane Hookom MVP
MS Access
----------------------------------------
> From: desertscroller@cox.net
>
> Hi All, I am developing a query on two joined tables that have a common field. (I don't think I can do what I want but here goes.) The common field may be blank in the main table on some records. This field is also the primary key in the second table. Since there is no corresponding entry ( for the blank field) the records are not displayed in the query. Is there away to show the records even though there is no common link on the record? Or do I need to create a record value in the secondary table that is always present; i.e., the primary key exist but no other data exits in the secondary table (a dummy record). This value could then be assigned in the primary table when the state is unknown.
>
> Hope I was able to example the issue.
> Using Access 2010.
> Rod
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar