Adjusting dates

  • Thread starter Thread starter Rich Zaleski
  • Start date Start date
R

Rich Zaleski

I am trying to figure out how to allow users to input a
date range on a form. I am also having issues with the
form showing in a landscape view. I check it, but it comes
up portrait each time. HELP
 
I can't help you with the landscape issue

I always put two TextBoxes - [txtStartDate] And [txtEndDate] - on my Reports screens and use them to set the date range for queries and reports. Just use: "Between [Forms]![frmReports]![txtStartDate] And [Forms]![frmReports]![txtEndDate]" as your criteria in the (source) queries

Hope this helps

Howard Brod


----- Rich Zaleski wrote: ----

I am trying to figure out how to allow users to input a
date range on a form. I am also having issues with the
form showing in a landscape view. I check it, but it comes
up portrait each time. HEL
 
I think I follow Howard, but I am not quite sure, could
you elaborate a bit more? where do I build
the "Between...And"? In the report I want? In the query?

Rich
-----Original Message-----
I can't help you with the landscape issue.

I always put two TextBoxes - [txtStartDate] And
Click to expand...
[txtEndDate] - on my Reports screens and use them to set
the date range for queries and reports. Just
use: "Between [Forms]![frmReports]![txtStartDate] And
[Forms]![frmReports]![txtEndDate]" as your criteria in the
(source) queries.
 
I think I follow Howard, but I am not quite sure, could
you elaborate a bit more? where do I build
the "Between...And"? In the report I want? In the query?
Click to expand...

On the Criteria line of the Query upon which you base the Report.
 
Back
Top