Date Lookup based on Combo Box

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

mattc66 via AccessMonster.com

I have a combo box that is looking up the ship date

I want it to display the ship dates grouped. I created query and only have
the ShipDate fld set to group.

It is displaying multiple dates for the same day because the fld also
contains the time. I set the properties to SHORT Date, but that didn't seem
to help.

Any ideas?

Matt
 
D

Douglas J. Steele

Create a query that uses the DateValue function on the ShipDate field (as
well as DISTINCT), and use that query as the RowSource for the combo box:

SELECT DISTINCT DateValue(ShipDate)
FROM MyTable
ORDER BY ShipDate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Look up a date 1
Date format in a combo box 1
return value based on combo box selection 3
sum combo box based on other combo box 2
Stored date is not being recognised 1
Date/Text field in Report 7
Copy a record into the same table 4
Change table text column lookup list 3

Top