Adding a Constant Row Result to SQL Query - MS Access
Say I have a table "tblItems":
    
    *ID*    |     *Name*
    1       |   First Item
    2       |  Second Item

and I want this to be populated in a drop-down in a form. How would I add a row:

    ALL     |    SHOW ALL

to become

    *ID*    |     *Name*
    1       |   First Item
    2       |  Second Item
    ALL     |    SHOW ALL

with one query to place in the `Row Source` for the combo box? I haven't been able to find Access syntax to do this..
Adding a Constant Row Result to SQL Query - MS Access
===

Say I have a table "tblItems":
    
    *ID*    |     *Name*
    1       |   First Item
    2       |  Second Item

and I want this to be populated in a drop-down in a form. How would I add a row:

    ALL     |    SHOW ALL

to become

    *ID*    |     *Name*
    1       |   First Item
    2       |  Second Item
    ALL     |    SHOW ALL

with one query to place in the `Row Source` for the combo box? I haven't been able to find Access syntax to do this..