Date Range on Crosstab Query to create a Reports

S

stvlai

Hi

I am having some problems using Date Range on Crosstab Query to create
a Reports.

I specify the 'StartDate' & 'EndDate' for the Date Range in the Query
Parameters Table. It prompt me for the Start & End Date. It works fine
in the CrossTab Query.

However, when I try to create a Report using the Report Wizard based
on the CrossTab Query with Date Range, it does not list any of the
Query Fields or Column at all. Just blank! If I remove the Date Range
from the CrossTab Query, then it show all the Query's fields. Strange!

Does anyone have any idea why it is doing this? Any suggestions or
ideas is very much appreciated. Thanks again.

Steven
 

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

Crosstab Date Range in Reports 3
Crosstab query fields do not show up in report 3
Date parameters won't work on crosstab report 1
Crosstab queries and reports 1
Setting Date Range on a crosstab 3
CrossTab Query Access Report - 1
Sub report based on Crosstab query 4
Creating Report Based on Crosstab Query 3

Top