different take on the date range question

[mech55]

For example, my report asks the user to enter a date range by poping up two boxes first one asks enter start and second asks enter end date
like below

Between [type the beginning date:] And [type the ending date:]

Is there any way to extract what the user types in for that and put it on a header in the report. So if they typed 8/29/05 and then 8/31/05, I want it to say 8/29/05 thru 8/31/05 on the report. Not just the last date which is how my query is sorted for duplication reasons.

thanks,

 

[Hayley Baxter]

Add a text box with a control source of:

=[start date]) & " to " & [end date]

Hay

 

[mech55]

That works but, now I have two sets of text boxes asking the same thing. I need to eliminate one...

 

[Hayley Baxter]

How about 2 text boxes

= [start date]
= [end date]

Hay

 

[Rich]

It's generally considered better practice to pass query parameters via a form, you can then simply reference these textboxes on your Report

 

[mech55]

so in the Query I would put something like

Forms![Day/Week/Month Form]![Combo15]

if I wanted to use the combo box in the form for the criteria?

 

[Rich]

Yes, not so sure about the name of the field though

 

[kirky007]

As everyone has helped me here is my effort...

Create a form with two unbound objects or combo box... name one StartDate and the other EndDate.

Create a query with the criteria something along the lines of...
Between [Forms]![Name of form]![StartDate] And [Forms]![Name of form]![EndDate]

Then create a report based upon this information.

Next create a macro on your form to preview this report and hence you do away with the two parameters for start date and end date.

Andy

 

[Rich]

Next create a macro on your form to preview this report and hence you do away with the two parameters for start date and end date.

Andy

Do away with macros and use VBA before you get to far into Access, they're not recommended

 

[mech55]

Thanks a lot, it works perfectly...

As far as macros, I know vb.net well but not vb6 so going backwards is annoying.