Show criteria entered

[Linda RQ]

Happy Sunday Everyone,

I have a report that I type in start date and end date. How can I get this
to display in my report title. I would like it to look like this.

From 1/1/08 to 1/31/08

Thanks,

Linda

 

[Evi]

Where are you typing in Start Date and End date?

If you are doing it in a form then put this into a text box in your report:

=Forms![YourFormsName].Form.[YourStartDateTextBox] & " To " &
Forms![YourFormsName].Form.[YourStartDateTextBox]

change the form and control names in the square brackets to fit your real
ones.

Evi

 

[Linda RQ]

Hi Evi,

I am running the report that is based on a query. The date critera is in
the query so, when I run the report I get a dialog box to enter Start Date
and then another to enter End Date. Sorry I wasnt specific but I didn't
know you could run a report from a form. I am also using access 2003.

Linda

Where are you typing in Start Date and End date?

If you are doing it in a form then put this into a text box in your
report:

=Forms![YourFormsName].Form.[YourStartDateTextBox] & " To " &
Forms![YourFormsName].Form.[YourStartDateTextBox]

change the form and control names in the square brackets to fit your real
ones.

Evi

Happy Sunday Everyone,

I have a report that I type in start date and end date. How can I get this
to display in my report title. I would like it to look like this.

From 1/1/08 to 1/31/08

Thanks,

Linda

 

[Linda RQ]

This is nice to know. I always put the criteria in a query to run reports
between dates so many times I have to make 2 queries if I don't want to
enter dates.

OK...I have tried several things...removed the criteria from the query
because I was getting prompted twice to enter start and end dates. I put
this in one text box [Enter Start Date]&" and "&[Enter End Date] but got an
error. If I make 2 text boxes one with start date and one with end date it
works but I can't get the and label I had to put in the middle of them to
center correctly because the space the datas take up is variable. I would
like this to be centered nicely at the top of my report right under the
title so it looks like this.

Paperwork Audit Percentages
From 1/1/08 to 1/31/08

Thanks,
Linda

Hi Evi,

I am running the report that is based on a query. The date critera
is in the query so, when I run the report I get a dialog box to enter
Start Date and then another to enter End Date. Sorry I wasnt
specific but I didn't know you could run a report from a form. I am
also using access 2003.

The boxes you are using for your parameter prompts [Enter Start Date] can
be referenced in your report just as if they were actual fields in the
query.

 

[fredg]

Hi Evi,

I am running the report that is based on a query. The date critera is in
the query so, when I run the report I get a dialog box to enter Start Date
and then another to enter End Date. Sorry I wasnt specific but I didn't
know you could run a report from a form. I am also using access 2003.

Linda

Where are you typing in Start Date and End date?

If you are doing it in a form then put this into a text box in your
report:

=Forms![YourFormsName].Form.[YourStartDateTextBox] & " To " &
Forms![YourFormsName].Form.[YourStartDateTextBox]

change the form and control names in the square brackets to fit your real
ones.

Evi

Happy Sunday Everyone,

I have a report that I type in start date and end date. How can I get this
to display in my report title. I would like it to look like this.

From 1/1/08 to 1/31/08

Thanks,

Linda

Add an unbound control to the report header.
Set it's control source to:
="For sales between " & Format([Enter Start Date],"mm/dd/yy") & " and
" & Format([Enter End Date],"mm/dd/yy")

The text within the brackets above must be identical to whatever the
bracketed text in the query criteria is.

 

[fredg]

This is nice to know. I always put the criteria in a query to run reports
between dates so many times I have to make 2 queries if I don't want to
enter dates.

OK...I have tried several things...removed the criteria from the query
because I was getting prompted twice to enter start and end dates. I put
this in one text box [Enter Start Date]&" and "&[Enter End Date] but got an
error. If I make 2 text boxes one with start date and one with end date it
works but I can't get the and label I had to put in the middle of them to
center correctly because the space the datas take up is variable. I would
like this to be centered nicely at the top of my report right under the
title so it looks like this.

Paperwork Audit Percentages
From 1/1/08 to 1/31/08

Thanks,
Linda

Hi Evi,

I am running the report that is based on a query. The date critera
is in the query so, when I run the report I get a dialog box to enter
Start Date and then another to enter End Date. Sorry I wasnt
specific but I didn't know you could run a report from a form. I am
also using access 2003.

The boxes you are using for your parameter prompts [Enter Start Date] can
be referenced in your report just as if they were actual fields in the
query.

See my other reply to this thread.
The text within the brackets must be IDENTICAL to the bracketed text
in the query criteria, and place spaces around the &'s as I have
below.

=" Paperwork Audit Percentages" & chr(13) & chr(10) & "From " &
Format([Enter Start Date],"mm/dd/yy") & " to " & Format([Enter End
Date],"mm/dd/yy")