Access 2003 Printing Query Parameter values onto your report.

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

 

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

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.

 

[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?

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.

 

[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?

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.

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

 

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

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.

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

 

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

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.

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

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.

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

 

[Carol]

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

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.

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.

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.

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