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
|
|||
|
|||
Adding all to a combo box
I have created a dialog box that allows me to select an
option button and then select an area that I want to filter to a report. I would like to add ALL to the combo box. Below is my select statement but I am not sure where to put select ALL. SELECT DISTINCT [Account Information].Area FROM [Account Information] GROUP BY [Account Information].Area; |
#2
|
|||
|
|||
Try this:
SELECT "ALL" as Area FROM [Account Information] UNION SELECT DISTINCT Area FROM [Account Information] Because you are using the DISTINCT clause, I don't think you need the Group By. -- --Roger Carlson 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 "jderrig" wrote in message ... I have created a dialog box that allows me to select an option button and then select an area that I want to filter to a report. I would like to add ALL to the combo box. Below is my select statement but I am not sure where to put select ALL. SELECT DISTINCT [Account Information].Area FROM [Account Information] GROUP BY [Account Information].Area; |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding an "All" selection to a combo box | Andrea | Using Forms | 1 | July 30th, 2004 09:08 PM |
adding 3 columns to a combo box | John | Charts and Charting | 0 | June 26th, 2004 06:25 PM |