Parameter criteria in Report

  • Thread starter Thread starter Bumbino
  • Start date Start date
B

Bumbino

I have a report that is generated based on 2 date parameters. The user can
choose any dates they want. Is there a way to capture the beginning and end
date entries to display them in the report??? Presently, when the report is
displayed, there is nothing on it to indicate the date range the user
selected. Help?
 
Currently I type the following into a textbox in the header of the report:
="Between " & [Type a beginning date for report header] & " and " & [Type an
ending date for report footer]

The problem with this is that every time you run the report you have to
enter the parameter dates twice - once to filter the query info, and another
to add the dates to the report. I'm wondering if there is a way around this?
Hopefully someone else will respond also...
 
If you are getting your values from parameter prompts then you should be able
to just use:

="Report Period From" & " " & [startDate] & " " & "Through" & " " & [endDate]

it will pull the values entered into the parameter prompt and place them in
the header. If you are using a form then you can also reference them this way
just by point to the form and the control.

="Report Period From" & " " & Forms!frmRisk!txtStartDate & " " & "Through" &
" " & Forms!frmRisk!txtEndDate

I hope this helps.

nikila40 said:
Currently I type the following into a textbox in the header of the report:
="Between " & [Type a beginning date for report header] & " and " & [Type an
ending date for report footer]

The problem with this is that every time you run the report you have to
enter the parameter dates twice - once to filter the query info, and another
to add the dates to the report. I'm wondering if there is a way around this?
Hopefully someone else will respond also...


Bumbino said:
I have a report that is generated based on 2 date parameters. The user can
choose any dates they want. Is there a way to capture the beginning and end
date entries to display them in the report??? Presently, when the report is
displayed, there is nothing on it to indicate the date range the user
selected. Help?
Click to expand...
Click to expand...
 
IMHO, parameter prompts are never a good idea
http://www.tek-tips.com/faqs.cfm?fid=6763.

You should consider using controls on forms and then referencing the
controls from within your report.
="Dates between " & Forms!frmDates!txtStart & " and " & Forms!frmDates!txtEnd
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


ATSBC03 said:
If you are getting your values from parameter prompts then you should be able
to just use:

="Report Period From" & " " & [startDate] & " " & "Through" & " " & [endDate]

it will pull the values entered into the parameter prompt and place them in
the header. If you are using a form then you can also reference them this way
just by point to the form and the control.

="Report Period From" & " " & Forms!frmRisk!txtStartDate & " " & "Through" &
" " & Forms!frmRisk!txtEndDate

I hope this helps.

nikila40 said:
Currently I type the following into a textbox in the header of the report:
="Between " & [Type a beginning date for report header] & " and " & [Type an
ending date for report footer]

The problem with this is that every time you run the report you have to
enter the parameter dates twice - once to filter the query info, and another
to add the dates to the report. I'm wondering if there is a way around this?
Hopefully someone else will respond also...


Bumbino said:
I have a report that is generated based on 2 date parameters. The user can
choose any dates they want. Is there a way to capture the beginning and end
date entries to display them in the report??? Presently, when the report is
displayed, there is nothing on it to indicate the date range the user
selected. Help?
Click to expand...
Click to expand...
Click to expand...
 
Thanks everyone! This is great info to know.

Duane Hookom said:
IMHO, parameter prompts are never a good idea
http://www.tek-tips.com/faqs.cfm?fid=6763.

You should consider using controls on forms and then referencing the
controls from within your report.
="Dates between " & Forms!frmDates!txtStart & " and " & Forms!frmDates!txtEnd
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


ATSBC03 said:
If you are getting your values from parameter prompts then you should be able
to just use:

="Report Period From" & " " & [startDate] & " " & "Through" & " " & [endDate]

it will pull the values entered into the parameter prompt and place them in
the header. If you are using a form then you can also reference them this way
just by point to the form and the control.

="Report Period From" & " " & Forms!frmRisk!txtStartDate & " " & "Through" &
" " & Forms!frmRisk!txtEndDate

I hope this helps.

nikila40 said:
Currently I type the following into a textbox in the header of the report:
="Between " & [Type a beginning date for report header] & " and " & [Type an
ending date for report footer]

The problem with this is that every time you run the report you have to
enter the parameter dates twice - once to filter the query info, and another
to add the dates to the report. I'm wondering if there is a way around this?
Hopefully someone else will respond also...


:

I have a report that is generated based on 2 date parameters. The user can
choose any dates they want. Is there a way to capture the beginning and end
date entries to display them in the report??? Presently, when the report is
displayed, there is nothing on it to indicate the date range the user
selected. Help?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top