B
Bryan W.H.
I have a table in access 2003:
Program, Text
Location, Text
Department, Text
Year, Text (FY02, FY03...)
Account, Number
Month, Text
Amount, Number
When I run a crosstab query as seen below it shows correct results for all
programs except for program "LJ" where there are no results.
Year, Row Heading (FY00)
Program, Row Heading
Account, Column Heading (301)
Amount, Sum Value
When I run a simple query off the same table it returns the correct results.
Table.*
Account (301)
Year (FY00)
Program (LJ)
The table contains 1,045,485 records from FY00 through FY05. Even if I add
LJ as criteria to the cross tab it still returns nothing in the results. Why
would the two queries return different results?
Thanks in advance.
Program, Text
Location, Text
Department, Text
Year, Text (FY02, FY03...)
Account, Number
Month, Text
Amount, Number
When I run a crosstab query as seen below it shows correct results for all
programs except for program "LJ" where there are no results.
Year, Row Heading (FY00)
Program, Row Heading
Account, Column Heading (301)
Amount, Sum Value
When I run a simple query off the same table it returns the correct results.
Table.*
Account (301)
Year (FY00)
Program (LJ)
The table contains 1,045,485 records from FY00 through FY05. Even if I add
LJ as criteria to the cross tab it still returns nothing in the results. Why
would the two queries return different results?
Thanks in advance.