ACCESS FEED: Re: [MS_AccessPros] Re: Field not meeting the join criteria

Rabu, 25 Mei 2011

Re: [MS_AccessPros] Re: Field not meeting the join criteria

That sure did. Thank you very much.

With warm regards,

Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947

1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training

From: Paul <pbaldy72@yahoo.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, May 25, 2011 4:31 PM
Subject: [MS_AccessPros] Re: Field not meeting the join criteria

Does this do what you want?

SELECT tblContact.ContactID, [FirstName] & " " & [LastName] & " " & [Suffix] AS
ContactName
FROM tblContact LEFT JOIN tlkpSuffixes ON tblContact.SuffixID =
tlkpSuffixes.SuffixID;

Paul

--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> I have this query:
>
> SELECT tblContact.ContactID, [FirstName] & " " & [LastName] & " " & [Suffix] AS ContactName
> FROM tblContact INNER JOIN tlkpSuffixes ON tblContact.SuffixID = tlkpSuffixes.SuffixID;
>
> It is returning nothing because there is no records with a Suffix. How can I work around that and display records that don't have a suffix?
>
> Thanks
>
> Arthur Lorenzini
> Sioux Falls, SD
>

[Non-text portions of this message have been removed]