Parmeter Display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a parmater query thta asks for the ending date in a range. I uses between 11/1/2003 and the parameter value. I want to be able to display only the parameter date on the report.
 
George said:
I have a parmater query thta asks for the ending date in a range. I
uses between 11/1/2003 and the parameter value. I want to be able to
display only the parameter date on the report.
Click to expand...
George,
If the parameter is written in the query as:
Between #11/1/2003# and [End Date]

Add an unbound control to the report header.
Set it's Control Source to:
= "For sales from 11/1/2003 and " & [End Date]

The text within the brackets must be identical to the query bracketed
text.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying date parameter on a multiple page report 3
PROBLEM - Report based on query that has criteria based on listbox 3
Display query parameters in a chart 5
Parameter Query In Report Title 3
Displaying date parameters on the report 2
Subreports and date parameters 1
Parameter Value as a Report Heading (Label/Text) 1
Access 2003 Printing Query Parameter values onto your report. 6

Back
Top