Date Lookup based on Combo Box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200606/1
.

Relevant Pages

  • Re: Select Subquery: To only display one year at a time
    ... Ship Year Ship Month...Invoiced...Final Ship Date ... JAN & FEB should not display because they are completed months. ... records do not display in this query because of the 2008 criteria in the Ship ... defeat the purpose of the subquery. ...
    (microsoft.public.access.queries)
  • Select Subquery: To only display one year at a time
    ... completed INVOICED and FINAL SHIP DATE fields. ... queries and in each I have criteria specifying for only one year to display. ... In my 2008 query the month of FEB is displaying because I now have an entry ... Is there a way to specify within this subquery or add another ...
    (microsoft.public.access.queries)
  • Re: Looking for Auto Navigation System to Take on Cruises
    ... lounge somewhere on the ship or ship's tv where that status is ... But it's only available when you're in your lounge or in your cabin. ... of the shipboard display. ... GPS receiver and paper maps. ...
    (rec.travel.cruises)
  • Re: Parting out FIREPOWER email me with your needs
    ... Bumper caps nice and white, plastics in good shape, boards in decent shape ... Cabinet sucks as it was ... in the ass to ship). ... I need a display, and one of the wiring harnesses for the display, to ...
    (rec.games.pinball)
  • Re: IJN Yamato
    ... They have it on display at my local hobby shop. ... a good ship modeler could probably ... IJN Yamato sectional kits? ... each a vertical cross section of one part of the ...
    (rec.models.scale)