Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Form to enter date range
8,273 views
Skip to first unread message
David Elliott
Mar 12, 2002, 5:31:43 PM3/12/02
to
I need a form to use for my query that has a start and end date range.
How can I make a form let me input the start and end date and open my form
or report?
How can I make a form let me input the start and end date and open my form
or report?
Thanks,
Dave
Donna
Mar 12, 2002, 5:57:19 PM3/12/02
to
You will need to set up a query with the fields you desire
in your form and report. In the date field criteria you
need to type the following, Between[Type the Beginning
Date]and[Type the Ending Date]
in your form and report. In the date field criteria you
need to type the following, Between[Type the Beginning
Date]and[Type the Ending Date]
You can type what ever message you would like to prompt
the user between each of the [].
You will need to build the form and the report off the
query.
This is how I use date ranges in reports and forms!
Hope this helps!
Donna
>.
>
David Elliott
Mar 12, 2002, 7:48:13 PM3/12/02
to
I already have the query that prompts for the dates, i need to know how to
make a form use the start and end date range to open my form or report.
make a form use the start and end date range to open my form or report.
"Donna" <Re...@wadleyrmc.com> wrote in message
news:2a7501c1ca19$437ca580$a5e62ecf@tkmsftngxa07...
Chuck
Mar 12, 2002, 9:53:52 PM3/12/02
to
David,
Do you want a form that you can enter the date range vaues
in rather than the pop up prompts from the query?
Do you want a form that you can enter the date range vaues
in rather than the pop up prompts from the query?
If so you should set the criteria for the date field in
your query to use the value from the form fields.
The criteria will be something like:
Between [Forms]![YourFormName]![txtStartDate] And [Forms]!
[YourFormName]![txtEndDate]
I hope this helps.
>.
>
0 new messages