B
Bryan W.H.
I have table and used a crosstab query to find the sums of amounts. The data
I received looked incorrect so I started a drill down process to verify. To
do this I started adding criteria to peel away layers of information until i
found the culprit. It looked like I was missing data in my table. However,
I wanted to be absolutely positive so I ran a simple query; the data is
there.
The Criteria in the simple query is the exact same as in the crosstab query.
In the simple query it returns data, in the crosstab query there is no data.
Can anyone give me any ideas as to why this error would appear.
Does a crosstab have a maximum number of records it can process?
Thanks for any help you can provide
I received looked incorrect so I started a drill down process to verify. To
do this I started adding criteria to peel away layers of information until i
found the culprit. It looked like I was missing data in my table. However,
I wanted to be absolutely positive so I ran a simple query; the data is
there.
The Criteria in the simple query is the exact same as in the crosstab query.
In the simple query it returns data, in the crosstab query there is no data.
Can anyone give me any ideas as to why this error would appear.
Does a crosstab have a maximum number of records it can process?
Thanks for any help you can provide