Two text boxes in a form

[qkimchi via AccessMonster.com]

Please help!
I have a query which contans a field called, "Received Date". I want to
create the paramenters in the form that prompt the users to enter min and max
dates.
Enter min Date:01/06/07 Enter Max Date:01/22/2007

Received Date
01/01/2007
01/06/2007
01/10/2007
01/15/2007
01/22/2007
02/08/2007
02/18/2007

So when the user enter 01/06/2007(min) and 01/22/2007(max) it only returns
these dates;
01/06/2007
01/10/2007
01/15/2007
01/22/2007

Thank you very much!

 

[Guest]

Use the between function on your field criteria for "Received Date"

To prompt the user:
between [Enter Start Date] and [Enter End Date]

To pick it up off a form:
between forms!FORMNAME.STARTDATE and forms!FORMNAME.ENDDATE

Hope this helps.

Damian.

 

[Al Campagna]

Q,
Place two unbound text controls on your form (frmMain) MinDate and MaxDate, and format
for Date.
Using the query design grid, based on your table, use the following criteria against
your ReceivedDate field... (while the form is Open)
Between Forms!frmMain!MinDate and Forms!frmMain!MaxDate
When the query runs, only RecievedDates between those two form values will be
returned.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[qkimchi via AccessMonster.com]

It works! Thank you very much!

Q,
Place two unbound text controls on your form (frmMain) MinDate and MaxDate, and format
for Date.
Using the query design grid, based on your table, use the following criteria against
your ReceivedDate field... (while the form is Open)
Between Forms!frmMain!MinDate and Forms!frmMain!MaxDate
When the query runs, only RecievedDates between those two form values will be
returned.

Please help!
I have a query which contans a field called, "Received Date". I want to

[quoted text clipped - 19 lines]

Thank you very much!