Data Ranges in a Form

[Guest]

I have created a form with 2 fields in which the user will enter the “FROMâ€
value of a date in one field (let’s say 01-01-2007) and the “TO†value of a
date in the other field (let’s say 01-10-2007).

Once the user enters this range of dates in the 2 fields of the form, I
would like the query to pull the info than contains all the data in the
ranges specified (let’s say data from 01-01-2007 and 01-10-2007 both
included). How do I link both fields in the form and the query?

 

[Azzna]

Hello,

In the query, your where clause should read
where NameOfTableFromDate >= Forms!FormName!FromDate
ANd NameOfTableToDate <= Forms!FormName!ToDate

So, you are going to need 1 pieces of information. You type in Forms
then an ! then the name of the form the data resides on, then ! then
the name of the field you are looking for. That will populate the
query. I hope that helps!

Susan