aarondewberry
IS-IT--Management
All
I am trying to create and combobox with the row source from a table SELECT [tblAgents].[Agent] FROM tblAgents;. But I also want to add another selection, at the end of the Agent, to the combobox called "Not Allocated".
"Not Allocated" is not found in any table.
Now I know i could just add a row, "Not Allocated", to the tblAgents.Agent field, but I don't want to do that.
I could also create another table and put "Not Allocated" in there, then create a simple Union All query using the tblAgents and my new table. But I don't want to do that either.
Is there any way I could write some sort of union qry using tblagents.Agent and add the extra selection of "Not Allocated" at the end of the agents names there?
Crazy request, i know!
Thanks
I am trying to create and combobox with the row source from a table SELECT [tblAgents].[Agent] FROM tblAgents;. But I also want to add another selection, at the end of the Agent, to the combobox called "Not Allocated".
"Not Allocated" is not found in any table.
Now I know i could just add a row, "Not Allocated", to the tblAgents.Agent field, but I don't want to do that.
I could also create another table and put "Not Allocated" in there, then create a simple Union All query using the tblAgents and my new table. But I don't want to do that either.
Is there any way I could write some sort of union qry using tblagents.Agent and add the extra selection of "Not Allocated" at the end of the agents names there?
Crazy request, i know!
Thanks
