How to search a table/query for a date range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bzeyger - 23 Jan 2008 01:59 GMT

I have an Access DB that contain multiple form, queries, tables, and reports.
I have one query that containes a various about of information (Name, Title,
Hire Date).
I have a form created with two text boxes and a command button. The user is
suppsed to enter a start date and an end date then press the command button.
The employees that fit into the date range get displayed. You do I get this
to work?

Right now it only didplays all the information. I am tring to get the date
ranges to function.

Reply to this Message

Tom van Stiphout - 23 Jan 2008 03:58 GMT

There are several ways. One is to set the form's Filter property. In
the command button's Click event write two lines of code:
Me.Filter = "HireDate BETWEEN #" & Me.txtStartDate & "# AND #" &
Me.txtEndDate & "#"
Me.FilterOn = True
(of course you substitute your own control and field names)

-Tom.

>I have an Access DB that contain multiple form, queries, tables, and reports.
>I have one query that containes a various about of information (Name, Title,
[quoted text clipped - 6 lines]
>Right now it only didplays all the information. I am tring to get the date
>ranges to function.

Reply to this Message