<div>
if ProjectFullId and ProjectID is numeric<br />
<br />
SELECT 0 As ProjectFullID, &quot;&lt;All&gt;&quot; As ProjectName, 0 As ProjectID From tblProjects<br />
UNION<br />
SELECT tblProjectFTE.ProjectFullI<wbr />d, tblProjectFTE.ProjectName,<wbr /> tblProjectFTE.ProjectID<br />
FROM tblProjects INNER JOIN tblProjectFTE ON tblProjects.ProjectID = tblProjectFTE.ProjectID<br />
WHERE (((tblProjects.Status) Not In (&quot;Closed&quot;,&quot;Excluded&quot;)));
</div>


if ProjectFullId and ProjectID is numeric

SELECT 0 As ProjectFullID, "<All>" As ProjectName, 0 As ProjectID From tblProjects
UNION
SELECT tblProjectFTE.ProjectFullId, tblProjectFTE.ProjectName, tblProjectFTE.ProjectID
FROM tblProjects INNER JOIN tblProjectFTE ON tblProjects.ProjectID = tblProjectFTE.ProjectID
WHERE (((tblProjects.Status) Not In ("Closed","Excluded")));

<div>
That was it, there were no rows in the table! &nbsp;I did not even think of that. &nbsp;I put a seed row in and it works now. &nbsp;Thank you,
</div>


That was it, there were no rows in the table!  I did not even think of that.  I put a seed row in and it works now.  Thank you,

<div>
<div class="content wysiwyg-content">
I have the below and even if no data is in the table, I want the combobox to at leas show the term &quot;[All]J&quot;. &nbsp;However, while it works in two other comboboxes, I cannot get this one to display the [All] term even if there is no data from the other union statement.<br />
<br />
SELECT &quot;[All]&quot; As ProjectFullID, &quot;[All]&quot; As ProjectName, &quot;[All]&quot; As ProjectID From tblProjects<br />
UNION<br />
SELECT tblProjectFTE.ProjectFullI<wbr />d, tblProjectFTE.ProjectName,<wbr /> tblProjectFTE.ProjectID<br />
FROM tblProjects INNER JOIN tblProjectFTE ON tblProjects.ProjectID = tblProjectFTE.ProjectID<br />
WHERE (((tblProjects.Status) Not In (&quot;Closed&quot;,&quot;Excluded&quot;)));
</div>
</div>


I have the below and even if no data is in the table, I want the combobox to at leas show the term "[All]J".  However, while it works in two other comboboxes, I cannot get this one to display the [All] term even if there is no data from the other union statement.

SELECT "[All]" As ProjectFullID, "[All]" As ProjectName, "[All]" As ProjectID From tblProjects
UNION
SELECT tblProjectFTE.ProjectFullId, tblProjectFTE.ProjectName, tblProjectFTE.ProjectID
FROM tblProjects INNER JOIN tblProjectFTE ON tblProjects.ProjectID = tblProjectFTE.ProjectID
WHERE (((tblProjects.Status) Not In ("Closed","Excluded")));

Add &quot;ALL&quot; to list, not showing up in ACCESS 200 Table/Query statement

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Add &quot;ALL&quot; to list, not showing up in ACCESS 200 Table/Query statement

Add "ALL" to list, not showing up in ACCESS 200 Table/Query statement