Hi all ..I am new in here ..I need some help
..I got table A with the field Number ...In the field Number ... I have records ...like 1,2,3 Then I make a crosstab query on Table A with the field Number to check how many 1,2 and 3 ...So it worked fine ...
Then I make a report on the query ...it shows fine when in the field Number , there is 1,2 and 3 ...
But when in Table A , there is no 1#, it can not generate the report and the Message is:"the Microsoft Jet can not know [1]" ...I really don't know why...
Any help thanks in advance...
..I got table A with the field Number ...In the field Number ... I have records ...like 1,2,3 Then I make a crosstab query on Table A with the field Number to check how many 1,2 and 3 ...So it worked fine ...
Then I make a report on the query ...it shows fine when in the field Number , there is 1,2 and 3 ...
But when in Table A , there is no 1#, it can not generate the report and the Message is:"the Microsoft Jet can not know [1]" ...I really don't know why...
Any help thanks in advance...
