How to get date from query into report

[ryan.fitzpatrick3]

I have a query QryretailFlour where in one of the fields I have a data
parameter

between [start date:] and [end date:] i.e. the person would input
1/1/2007 and 12/31/2007 in the input box upon running the query.

I have a report that pulls up this query. is there away I can put a
label box or text box in the header of the report that will state
"Pulled between 1/1/2007 and 12/31/2007"?

Thanks in advance.

Ryan

 

[fredg]

I have a query QryretailFlour where in one of the fields I have a data
parameter

between [start date:] and [end date:] i.e. the person would input
1/1/2007 and 12/31/2007 in the input box upon running the query.

I have a report that pulls up this query. is there away I can put a
label box or text box in the header of the report that will state
"Pulled between 1/1/2007 and 12/31/2007"?

Thanks in advance.

Ryan

Add an unbound text control to the Report Header.
Set it's Control Source to:
= "Pulled between " & [start date:] & " and " & [end date:]

The text within the brackets MUST be identical to the bracketed text
in the query.

 

[ryan.fitzpatrick3]

I copied and pasted what you wrote, for it's the same in my query, and
it didn't work, it reasks for the date again.

I have a query QryretailFlour where in one of the fields I have a data
parameter

between [start date:] and [end date:] i.e. the person would input
1/1/2007 and 12/31/2007 in the input box upon running the query.

I have a report that pulls up this query. is there away I can put a
label box or text box in the header of the report that will state
"Pulled between 1/1/2007 and 12/31/2007"?

Thanks in advance.

Ryan

Add an unbound text control to the Report Header.
Set it's Control Source to:
= "Pulled between " & [start date:] & " and " & [end date:]

The text within the brackets MUST be identical to the bracketed text
in the query.

 

[fredg]

I copied and pasted what you wrote, for it's the same in my query, and
it didn't work, it reasks for the date again.

I have a query QryretailFlour where in one of the fields I have a data
parameter

between [start date:] and [end date:] i.e. the person would input
1/1/2007 and 12/31/2007 in the input box upon running the query.

I have a report that pulls up this query. is there away I can put a
label box or text box in the header of the report that will state
"Pulled between 1/1/2007 and 12/31/2007"?

Thanks in advance.

Ryan

Add an unbound text control to the Report Header.
Set it's Control Source to:
= "Pulled between " & [start date:] & " and " & [end date:]

The text within the brackets MUST be identical to the bracketed text
in the query.

I suspect the bracketed text is not identical.

1) Are you sure the second parameter prompt is asking for the SAME
value? The prompt title will say "Enter Parameter Value" then below,
in the gray dialog part
enter start:
(or enter end.
Make sure the prompts are spelled identically to, and includes any
spaces or punctuation used in, the query criteria.
[Enter start:] is not identical to [enter start] or [enterstart:]

2) Are you sure the query is the report's record source?

If you still have trouble finding where the 2nd prompt is coming from,
copy and paste the report's record source query SQL and also the
control source expression you are using, as well as the exact
parameter prompt you are getting, into a reply message in this thread.

 

[ryan.fitzpatrick3]

Ok, you're right about being precise. here is my issue this is in the
query field to prompt a input box for between dates

Between [Start Date ~ Format is year then week 200701:] And [End Date
~ Same format as Start Date:]

Normally I put between [Start Date:] and [End Date:] but would like to
have the "Format is year then week 200701" as to how to input the
proper date since really it's not in 01/01/07 format but 200701, which
is 2007 wk 1. query pulls in weeks. So how can I put the note in the
messagebox and just have the between dates show in the report?

I copied and pasted what you wrote, for it's the same in my query, and
it didn't work, it reasks for the date again.

I have a query QryretailFlour where in one of the fields I have a data
parameter
between [start date:] and [end date:] i.e. the person would input
1/1/2007 and 12/31/2007 in the input box upon running the query.
I have a report that pulls up this query. is there away I can put a
label box or text box in the header of the report that will state
"Pulled between 1/1/2007 and 12/31/2007"?
Thanks in advance.
Ryan
Add an unbound text control to the Report Header.
Set it's Control Source to:
= "Pulled between " & [start date:] & " and " & [end date:]
The text within the brackets MUST be identical to the bracketed text
in the query.

I suspect the bracketed text is not identical.

1) Are you sure the second parameter prompt is asking for the SAME
value? The prompt title will say "Enter Parameter Value" then below,
in the gray dialog part
enter start:
(or enter end.
Make sure the prompts are spelled identically to, and includes any
spaces or punctuation used in, the query criteria.
[Enter start:] is not identical to [enter start] or [enterstart:]

2) Are you sure the query is the report's record source?

If you still have trouble finding where the 2nd prompt is coming from,
copy and paste the report's record source query SQL and also the
control source expression you are using, as well as the exact
parameter prompt you are getting, into a reply message in this thread.

 

[fredg]

Ok, you're right about being precise. here is my issue this is in the
query field to prompt a input box for between dates

Between [Start Date ~ Format is year then week 200701:] And [End Date
~ Same format as Start Date:]

Normally I put between [Start Date:] and [End Date:] but would like to
have the "Format is year then week 200701" as to how to input the
proper date since really it's not in 01/01/07 format but 200701, which
is 2007 wk 1. query pulls in weeks. So how can I put the note in the
messagebox and just have the between dates show in the report?

I copied and pasted what you wrote, for it's the same in my query, and
it didn't work, it reasks for the date again.

I have a query QryretailFlour where in one of the fields I have a data
parameter

between [start date:] and [end date:] i.e. the person would input
1/1/2007 and 12/31/2007 in the input box upon running the query.

I have a report that pulls up this query. is there away I can put a
label box or text box in the header of the report that will state
"Pulled between 1/1/2007 and 12/31/2007"?

Thanks in advance.

Ryan

Add an unbound text control to the Report Header.
Set it's Control Source to:
= "Pulled between " & [start date:] & " and " & [end date:]

The text within the brackets MUST be identical to the bracketed text
in the query.

I suspect the bracketed text is not identical.

1) Are you sure the second parameter prompt is asking for the SAME
value? The prompt title will say "Enter Parameter Value" then below,
in the gray dialog part
enter start:
(or enter end.
Make sure the prompts are spelled identically to, and includes any
spaces or punctuation used in, the query criteria.
[Enter start:] is not identical to [enter start] or [enterstart:]

2) Are you sure the query is the report's record source?

If you still have trouble finding where the 2nd prompt is coming from,
copy and paste the report's record source query SQL and also the
control source expression you are using, as well as the exact
parameter prompt you are getting, into a reply message in this thread.

You can enter the text of the Gettysburg Address if you wish, as long
as you have EXACTLY the same text in the control source brackets that
is in the brackets in the query criteria.

= "Pulling between " & [Start Date ~ Format is year then week
200701:] & " and " & [End Date ~ Same format as Start Date:]

The above should be all on one line in the control source.