Query Help

  • Thread starter Thread starter Tony Schlak
  • Start date Start date
T

Tony Schlak

I have a table that has 5 options that populate a drop down menu in one of
my forms. The users have asked if there would be a way to have a selection
that has ALL. So if they were to have picked ALL they would have all entries
returned not just one.

I.E.
100 = black
101 = blue
102 = Red

Select 100 and it returns all Black

Need one that has All = 100 and 101 and 102
 
Hi Tony

Let's assume the rowsource of your combo box looks like this:

Select OptionCode, OptionName from OptionsTable order by OptionName;

You need to change it to a UNION query that looks like this:

Select 0 as OptionCode, "<ALL>" as OptionName from OptionsTable
UNION
Select OptionCode, OptionName from OptionsTable order by OptionName;
 
Back
Top