Parmeter Display

G

George Schneider

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.
 
F

fredg

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.
 

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

Creating a Chart on form from selected data in query. 0
Display weeks from a Milestone 0
PROBLEM - Report based on query that has criteria based on listbox 3
Countdown macro - display settings 2
Displaying date parameter on a multiple page report 3
Word macro that can call cells out of Excel for a find and replace 0
Extract Text in braquet and list of terms from 2 Docs 3
Date Range in Header 1

Top