multiselect list box with date range

• peter sauven

  Grasshopper

  Points: 11

  More actions

  April 12, 2008 at 6:49 am

  #76959

  I attach an MDB that the has the multiselect listbox

  control. I would however, like to include on the same form

  a criteria for a date range; start date, end date and then

  build that into the sql when I run the query.

  I woiuld also like to make the "All" stay at the top of the

  list box.

  Can anyone please help me on these 2 items.

  Many thanks

• wazz

  SSC Enthusiast

  Points: 175

  More actions

  August 12, 2008 at 4:22 am

  #856567

  it's been a while since you posted but i think it's working now. don't use 'date' as the name of a field. hth.

  "You met me at a very strange time in my life." - Tyler Durden

• Naked Ape

  Ten Centuries

  Points: 1095

  More actions

  August 13, 2008 at 4:37 pm

  #857775

  You can sort the list to put ALL at the top using the following query;

  SELECT DISTINCT tblCompanies.strCompanyCounty, 1

  FROM tblCompanies

  UNION

  select "All", 0

  from tblCompanies

  order by 2;

  🙂

  Chris