C
CW
I am reporting on orders analysed by advertising source.
I have built my first crosstab query that works fine, and then a report
based on that which also works OK.
However, we need to select the date range (order date) for which it is
reporting.
In the past with ordinary select queries I have simply added Between [Enter
start date] And [Enter end date] to the appropriate date field column in the
design grid and it has worked fine.
But on this one it makes no difference - it either continues to display the
whole set of data, or nothing at all, depending on the syntax I use.
Is there something different about crosstab queries?
I assume I am correct in adding these parameters to the underlying query and
not to the report??
Could you please advise exactly what I should enter, and where, to achieve
what I want?
Many thanks
CW
I have built my first crosstab query that works fine, and then a report
based on that which also works OK.
However, we need to select the date range (order date) for which it is
reporting.
In the past with ordinary select queries I have simply added Between [Enter
start date] And [Enter end date] to the appropriate date field column in the
design grid and it has worked fine.
But on this one it makes no difference - it either continues to display the
whole set of data, or nothing at all, depending on the syntax I use.
Is there something different about crosstab queries?
I assume I am correct in adding these parameters to the underlying query and
not to the report??
Could you please advise exactly what I should enter, and where, to achieve
what I want?
Many thanks
CW