Senin, 25 Juli 2011

Re: [MS_AccessPros] records not displaying in a report

 

John;
As always Thanx, It works as advertised.
Walter

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar