Select all dates in month from month and year in text box?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LeeZard - 03 Mar 2008 15:30 GMT

I have a form to run reports. All reports are run based on the month and
year but the table data contains actual dates. On the form the client enters
03/2007 in a text box to select reports containing data for March 2007. The
text box has a format mm/yyyy. The table data has fields defined as
Date/Time. Data looks like 3/15/2007. How can I use the month and year from
the text box my form to select all of the dates that fall within the month
and year requested?

Reply to this Message

Jerry Whittle - 03 Mar 2008 16:38 GMT

In the criteria of the query that drives the report:

Between [Forms]![frmParameterDates]![txtParameter] And
(DateAdd("m",1,[Forms]![frmParameterDates]![txtParameter])-0.0001)

Make sure to use the actual form and field name. Remember that the form must
stay open but can be hidden or invisible.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have a form to run reports. All reports are run based on the month and
> year but the table data contains actual dates. On the form the client enters
[quoted text clipped - 3 lines]
> the text box my form to select all of the dates that fall within the month
> and year requested?

Reply to this Message