Access 2003 Printing Query Parameter values onto your report.

C

Carol

I have added the following to my report: (Note: I have a parameter set in my
query for data to display between two dates)

I added 2 text boxs to my report header (1 for the start date and 1 for
the end date):
Label: Start Date
Text box: =Reports![rptTest]![Enter Start Date]

Label: End Date
=Reports![rptTest]![Enter End Date]

Once I run the report I have to enter the query parameter and then the
report pops up the with Start and End Date and then the date stores in my
text box, however, I have to enter the date two times????

Any help will be greatly appreciated.
 
F

fredg

I have added the following to my report: (Note: I have a parameter set in my
query for data to display between two dates)

I added 2 text boxs to my report header (1 for the start date and 1 for
the end date):
Label: Start Date
Text box: =Reports![rptTest]![Enter Start Date]

Label: End Date
=Reports![rptTest]![Enter End Date]

Once I run the report I have to enter the query parameter and then the
report pops up the with Start and End Date and then the date stores in my
text box, however, I have to enter the date two times????

Any help will be greatly appreciated.
Click to expand...

Add one text control to the report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

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

Carol

I am still having to enter my dates twice. The query parameter and the report
parameter. How can I just enter the date once?

fredg said:
I have added the following to my report: (Note: I have a parameter set in my
query for data to display between two dates)

I added 2 text boxs to my report header (1 for the start date and 1 for
the end date):
Label: Start Date
Text box: =Reports![rptTest]![Enter Start Date]

Label: End Date
=Reports![rptTest]![Enter End Date]

Once I run the report I have to enter the query parameter and then the
report pops up the with Start and End Date and then the date stores in my
text box, however, I have to enter the date two times????

Any help will be greatly appreciated.
Click to expand...

Add one text control to the report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

The text within the brackets above must be identical to the bracketed
text in the query criteria.
Click to expand...
 
F

fredg

I am still having to enter my dates twice. The query parameter and the report
parameter. How can I just enter the date once?

fredg said:
I have added the following to my report: (Note: I have a parameter set in my
query for data to display between two dates)

I added 2 text boxs to my report header (1 for the start date and 1 for
the end date):
Label: Start Date
Text box: =Reports![rptTest]![Enter Start Date]

Label: End Date
=Reports![rptTest]![Enter End Date]

Once I run the report I have to enter the query parameter and then the
report pops up the with Start and End Date and then the date stores in my
text box, however, I have to enter the date two times????

Any help will be greatly appreciated.
Click to expand...

Add one text control to the report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

The text within the brackets above must be identical to the bracketed
text in the query criteria.
Click to expand...
Click to expand...

Please copy and paste into a reply message the EXACT query SQL and the
EXACT control source of the unbound control in the report.
 
C

Carol

Query SQL:
This is what I have in the criteria in my query in design view.
Between [Enter Start Date:] And [Enter End Date:]

QUERY STATEMENT:
SELECT dbo_CRACommentCard.provided_tools_for_job_search,
dbo_CRACommentCard.dateAdded
FROM dbo_CRACommentCard
WHERE (((dbo_CRACommentCard.provided_tools_for_job_search) Between [Enter
Start Date:] And [Enter End Date:]));

REPORT CONTROL I entered 1st:
=[Reports]![rptTest]![Enter Start Date]
=Reports!rptTest![Enter End Date]

The way you suggested:
="For Sales between" & [Enter Start Date] & "and" & [Enter End Date]

Thanks for all your help, it is greatly appreciated.

fredg said:
I am still having to enter my dates twice. The query parameter and the report
parameter. How can I just enter the date once?

fredg said:
On Mon, 26 Nov 2007 14:43:11 -0800, Carol wrote:

I have added the following to my report: (Note: I have a parameter set in my
query for data to display between two dates)

I added 2 text boxs to my report header (1 for the start date and 1 for
the end date):
Label: Start Date
Text box: =Reports![rptTest]![Enter Start Date]

Label: End Date
=Reports![rptTest]![Enter End Date]

Once I run the report I have to enter the query parameter and then the
report pops up the with Start and End Date and then the date stores in my
text box, however, I have to enter the date two times????

Any help will be greatly appreciated.

Add one text control to the report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

The text within the brackets above must be identical to the bracketed
text in the query criteria.
Click to expand...
Click to expand...

Please copy and paste into a reply message the EXACT query SQL and the
EXACT control source of the unbound control in the report.
Click to expand...
 
F

fredg

Query SQL:
This is what I have in the criteria in my query in design view.
Between [Enter Start Date:] And [Enter End Date:]

QUERY STATEMENT:
SELECT dbo_CRACommentCard.provided_tools_for_job_search,
dbo_CRACommentCard.dateAdded
FROM dbo_CRACommentCard
WHERE (((dbo_CRACommentCard.provided_tools_for_job_search) Between [Enter
Start Date:] And [Enter End Date:]));

REPORT CONTROL I entered 1st:
=[Reports]![rptTest]![Enter Start Date]
=Reports!rptTest![Enter End Date]

The way you suggested:
="For Sales between" & [Enter Start Date] & "and" & [Enter End Date]

Thanks for all your help, it is greatly appreciated.

fredg said:
I am still having to enter my dates twice. The query parameter and the report
parameter. How can I just enter the date once?

:

On Mon, 26 Nov 2007 14:43:11 -0800, Carol wrote:

I have added the following to my report: (Note: I have a parameter set in my
query for data to display between two dates)

I added 2 text boxs to my report header (1 for the start date and 1 for
the end date):
Label: Start Date
Text box: =Reports![rptTest]![Enter Start Date]

Label: End Date
=Reports![rptTest]![Enter End Date]

Once I run the report I have to enter the query parameter and then the
report pops up the with Start and End Date and then the date stores in my
text box, however, I have to enter the date two times????

Any help will be greatly appreciated.

Add one text control to the report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

The text within the brackets above must be identical to the bracketed
text in the query criteria.
Click to expand...

Please copy and paste into a reply message the EXACT query SQL and the
EXACT control source of the unbound control in the report.
Click to expand...
Click to expand...

Did you miss this line in my original reply?
The text within the brackets above must be identical to the bracketed
text in the query criteria.
Click to expand...

[Enter Start Date:] is NOT identical to [Enter Start Date].
[Enter End Date:] is NOT identical to [Enter End Date].
Your Query SQL parameters include a colon.
Your Report control's control source does not include the colons.
Either change the query parameter and remove the colons, or change the
report control's control source and add the colons.
 
C

Carol

Thanks for the help. It worked great once I removed the colon.

fredg said:
Query SQL:
This is what I have in the criteria in my query in design view.
Between [Enter Start Date:] And [Enter End Date:]

QUERY STATEMENT:
SELECT dbo_CRACommentCard.provided_tools_for_job_search,
dbo_CRACommentCard.dateAdded
FROM dbo_CRACommentCard
WHERE (((dbo_CRACommentCard.provided_tools_for_job_search) Between [Enter
Start Date:] And [Enter End Date:]));

REPORT CONTROL I entered 1st:
=[Reports]![rptTest]![Enter Start Date]
=Reports!rptTest![Enter End Date]

The way you suggested:
="For Sales between" & [Enter Start Date] & "and" & [Enter End Date]

Thanks for all your help, it is greatly appreciated.

fredg said:
On Mon, 26 Nov 2007 15:31:01 -0800, Carol wrote:

I am still having to enter my dates twice. The query parameter and the report
parameter. How can I just enter the date once?

:

On Mon, 26 Nov 2007 14:43:11 -0800, Carol wrote:

I have added the following to my report: (Note: I have a parameter set in my
query for data to display between two dates)

I added 2 text boxs to my report header (1 for the start date and 1 for
the end date):
Label: Start Date
Text box: =Reports![rptTest]![Enter Start Date]

Label: End Date
=Reports![rptTest]![Enter End Date]

Once I run the report I have to enter the query parameter and then the
report pops up the with Start and End Date and then the date stores in my
text box, however, I have to enter the date two times????

Any help will be greatly appreciated.

Add one text control to the report header.
Set it's control source to:
="For sales between " & [Enter Start Date] & " and " & [Enter End
Date]

The text within the brackets above must be identical to the bracketed
text in the query criteria.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Please copy and paste into a reply message the EXACT query SQL and the
EXACT control source of the unbound control in the report.
Click to expand...
Click to expand...

Did you miss this line in my original reply?
The text within the brackets above must be identical to the bracketed
text in the query criteria.
Click to expand...

[Enter Start Date:] is NOT identical to [Enter Start Date].
[Enter End Date:] is NOT identical to [Enter End Date].
Your Query SQL parameters include a colon.
Your Report control's control source does not include the colons.
Either change the query parameter and remove the colons, or change the
report control's control source and add the colons.
Click to expand...
 

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

print a date range from parameter query on a report header? 2
Parameter Value as a Report Heading (Label/Text) 1
Parameter Values in Report Title 4
Using Form for Criteria for Report 3
Parameter Query In Report Title 3
Show Parameter Information in Report Footer 1
How can I Display Parameter Query Values in Report? 3
Reference controls on a dialogue form as the parameters 1

Top