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
|
|||
|
|||
"all" in dropdown not working for query
I have a dropdown that is populated by the following query - but it
doesn't do what I want. SELECT DISTINCT [Division group cross table].Division FROM [Division group cross table] UNION select '(All)' from [division group cross table] ORDER BY [Division group cross table].Division; I want the "all" part of it to remove the restrictive criteria. I have seen some postings that tell you to use another column that is invisible to the user. How do I add this other column to this query? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I create a dropdown within a dropdown? | Joyce Keller | General Discussion | 1 | December 5th, 2005 04:02 PM |
Dropdown List Error | cpr | General Discussion | 4 | June 18th, 2005 06:05 PM |
Outlook Rules not Working | Marty | General Discussion | 0 | May 6th, 2005 05:58 PM |
Working time and days | Nortos | Worksheet Functions | 5 | May 6th, 2005 04:17 PM |
Working time and days | Nortos | General Discussion | 1 | May 6th, 2005 03:47 PM |