ACCESS FEED: RE: [MS_AccessPros] Union query problem

Selasa, 18 Maret 2014

RE: [MS_AccessPros] Union query problem

That does it indeed, Duane! Thanks very much

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Tuesday, March 18, 2014 3:04 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Union query problem

Glenn,

I think you only need to change out the "FROM tblFamilyNames" to a table that will always have at least one record.

Duane Hookom MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: argeedblu@gmail.com
Date: Tue, 18 Mar 2014 11:52:05 -0700
Subject: [MS_AccessPros] Union query problem

I use a union query to populate the row source of a combo box. When the underlying table tblFamilyNames for the first sentence in the query, the query returns no records.
SELECT tblFamilyNames.FamilyNameID,tblFamilyNames.FamilyName FROM tblFamilyNames UNION SELECT "A","<New Family Name>" FROM tblFamilyNames UNION SELECT "B" ,"<Type Family Name>" FROM tblFamilyNames
ORDER BY tblFamilyNames.FamilyName;
I want the combo list to always include <Type Family Name> and <New Family Name> even with tblFamilyNames has no records so that the combo will appear the same when the application is new as it will once tblFamilyNames is populated.
How can I re-word my query to make this happen?

Glenn