Cross Tab Query

[Haytham]

Hi All...
I have a form based on Cross Tab Query to show the Orders of a company in the chosen month and year.
My Columns are Day: 1,2,3,.....,31.
The cross tab query is limited to few fields getting a data from another query with more fields.
Every thing works perfect. But, if I have No data for a particular month/year, still it gives me a records with 0 result.
I tried to avoid this zero th' my query by setting a criteria <> 0 but it did not work.
Is there anyway to avoid this 0 in my form and report.
Hope explanation is clear.
Thanks in advance

 

[Alexandre]

Try <>Null.
Also, you probalbly have your crosstab query based on another query gathering theinfo you need? The put the criteria in the base query, not in the crosstab.

Alex

 

[Haytham]

Great help Alexandre.
I set the criteria in the based query as <>0 since the value in the field is 0 and it works well.
Very thankful.

 

[Alexandre]

Alex:1 - Queries:0