Walter-
By "blank" I assume you mean a Null value in a field that participates in a
relationship. For that, you can use an OUTER JOIN to include all records from
the suspect table and any matching rows from the related ones. Double-click the
join line in your query design to see the join options dialog box to change how
the join works.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
Sent: Monday, July 25, 2011 4:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] records not displaying in a report
Hello Group:
Back with one more problem.
I have a query made up of several tables ,most apply a readable string value to
an id field linked to the primary table.
I have discovered that if I have a blank field, for what ever reason, the entire
record the blank field is in doesn't become part of the query result.
Is there a way to include the record in spite of the missing field?
Walter Griffin
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar