D
dab1477
In an attempt to clarify a previous post...
I have tried to insert a text box in the header and
sourced as follows:
<="Between "&[Enter Start Date]"&"And "[Enter End Date]"<
The above still shows a "$name?" error.
I've tired to insert 2 text boxes and source each to the
query using Parameters. This give me an error stating
that "...database engine does not recognize [Start Date]as
a valid name or expression. I've tried using JUST
Paremeters and the Between/And expression within the
query. No Luck.
How do I get something in the Report header to show the
same date range that I am using in my query?
I apologize that this is a repeat, but I fear that my
problem goes unanswered based upon my problems with
previous response.
Original post:........
Thanks in advance for the assist.
I have a report driven from a query where the query
contains the expression: "Between [Start] and [End}". The
report graphs the sum of 2 fields based upon a start and
end date. I place the data graphically into the detail
section of the report.
My Problem:
I want to show the range of the expression in the Report
Header. I've tried to bind a text box to the Date field
of the query. Because of the expression "Between[]and[]"
it will not read any date - the Start nor End.
What must I do to show a date in my report header based
upon a date entered into the query?
I am able to get the report to run and graphically display
in the report, but my audience will have no way of knowing
the date range of the data displayed in the report. I am
trying to avoid a manual entry into the report. Even
so...I am not adverse to a manual entry if it can be done
without the user accessing the design mode of the report.
Thanks again from a self taught (via this group)novice.
I have tried to insert a text box in the header and
sourced as follows:
<="Between "&[Enter Start Date]"&"And "[Enter End Date]"<
The above still shows a "$name?" error.
I've tired to insert 2 text boxes and source each to the
query using Parameters. This give me an error stating
that "...database engine does not recognize [Start Date]as
a valid name or expression. I've tried using JUST
Paremeters and the Between/And expression within the
query. No Luck.
How do I get something in the Report header to show the
same date range that I am using in my query?
I apologize that this is a repeat, but I fear that my
problem goes unanswered based upon my problems with
previous response.
Original post:........
Thanks in advance for the assist.
I have a report driven from a query where the query
contains the expression: "Between [Start] and [End}". The
report graphs the sum of 2 fields based upon a start and
end date. I place the data graphically into the detail
section of the report.
My Problem:
I want to show the range of the expression in the Report
Header. I've tried to bind a text box to the Date field
of the query. Because of the expression "Between[]and[]"
it will not read any date - the Start nor End.
What must I do to show a date in my report header based
upon a date entered into the query?
I am able to get the report to run and graphically display
in the report, but my audience will have no way of knowing
the date range of the data displayed in the report. I am
trying to avoid a manual entry into the report. Even
so...I am not adverse to a manual entry if it can be done
without the user accessing the design mode of the report.
Thanks again from a self taught (via this group)novice.