If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
NotInList
I am not sure if this is even possible but I will ask. I have a form that
has 2 combo boxes in it. The first selects a department from a Value List. The second combo box will offer a selection of processes from a list that is filtered by the first combo box. I am using this to filter a query for a report becasue after you select the process an option box with 3 choices filters open, closed or all records. My question is that with the second combo box I would like to have an All Processes without adding it to the table. I currently use SELECT Proces.Process, Proces.ProcessID FROM Proces ORDER BY [Process]; as my rowsource with 2 bound columns. I want to add the All Processes to the list so the option of showing all the processes in the end report for a particular department. Any guidance woud be helpful. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#2
|
|||
|
|||
NotInList
Try something like this:
SELECT Proces.Process, Proces.ProcessID FROM Proces UNION SELECT "-All Processes-", "*" FROM Process ORDER BY [Process]; Then you can use the LIKE comparison in your filtering query. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "rollvoer99 via AccessMonster.com" u40720@uwe wrote in message news:8254f7e532464@uwe... I am not sure if this is even possible but I will ask. I have a form that has 2 combo boxes in it. The first selects a department from a Value List. The second combo box will offer a selection of processes from a list that is filtered by the first combo box. I am using this to filter a query for a report becasue after you select the process an option box with 3 choices filters open, closed or all records. My question is that with the second combo box I would like to have an All Processes without adding it to the table. I currently use SELECT Proces.Process, Proces.ProcessID FROM Proces ORDER BY [Process]; as my rowsource with 2 bound columns. I want to add the All Processes to the list so the option of showing all the processes in the end report for a particular department. Any guidance woud be helpful. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#3
|
|||
|
|||
NotInList
Works, thats exactly what I was looking for the UNION is what I was missing.
Thanks SELECT Proces.Process, Proces.ProcessID FROM Proces UNION SELECT "-All Processes-", "*" FROM Process ORDER BY [Process]; -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|