use calendar control in unbound form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Walter - 19 Jul 2006 22:09 GMT

I have a query that reads a date field:

Between [Forms]![pickdate]![fromdate] And [Forms]![pickdate]![todate]

The fromdate and todate values come from a calendar control in an unbound
form. However, the todate is not inclusive as there are missing records. Any
ideas would be great.

Reply to this Message

Michel Walsh - 20 Jul 2006 00:36 GMT

Hi,

Add 1 to todate since by default, the time is, say, at 00:00:00 as in July
17, 2006 at 00:00:00. So, July 17, 2006, 06:00:00 is AFTER the limit you
supplied. Adding 1 (day = 24 hour) correct the situation.

Between [Forms]![pickdate]![fromdate] And CDate([Forms]![pickdate]![todate])
+ 1

Hoping it may help,
Vanderghast, Access MVP

>I have a query that reads a date field:
>
[quoted text clipped - 4 lines]
> Any
> ideas would be great.

Reply to this Message

Walter - 20 Jul 2006 14:45 GMT

Thanks for the prompt reply, Michael.

The query formula makes sense but still does not work. Funny thing is the
query returns all records if I use a textbox to capture the fromdate and
todate.

I checked the properties in the calendar box but did not see any relevant
paramenter.

> Hi,
>
[quoted text clipped - 16 lines]
> > Any
> > ideas would be great.

Reply to this Message