Show First and Last Date

[khashid via AccessMonster.com]

I have created a report based on Query, that asks for Begining Date and
Ending Date.

Now in the report I have created to Text Boxes to show the Dates that
represents report. I have thought If I can use the Date field from First
records as Start Date and the Date field from Last record as Ending Date it
would solve my problem. But how would I do that?

In other words if I want to show first record of Date field what
code/expression should I enter.

Also can I have a Button on the report to export it to Excel or Word?

 

[Guest]

Are you just attempting to display the values entered by the user? Or, do you
want to display the minimum and maximum dates from your report? Or, do you
actually expect to display the dates from the first and last records from
your report?

You can't place a functional button on a report.

 

[khashid via AccessMonster.com]

I want to to display the dates from the first and last records from report

Are you just attempting to display the values entered by the user? Or, do you
want to display the minimum and maximum dates from your report? Or, do you
actually expect to display the dates from the first and last records from
your report?

You can't place a functional button on a report.

I have created a report based on Query, that asks for Begining Date and
Ending Date.

[quoted text clipped - 8 lines]

Also can I have a Button on the report to export it to Excel or Word?

 

[khashid via AccessMonster.com]

Or if its possible that I could show the dates user has entered?

I want to to display the dates from the first and last records from report

Are you just attempting to display the values entered by the user? Or, do you
want to display the minimum and maximum dates from your report? Or, do you

[quoted text clipped - 8 lines]

 

[Marshall Barton]

I want to to display the dates from the first and last records from report

You can display the query parameters just by using a text
box bound to the ** exact** same thing you used in the
query.

You can display the earliest and latest date for all records
in the report by using a text box expression like:
=Min(datefield)
=Max(datefield)