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

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

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.

http://www.access-programmers.co.uk/ubb/smile.gif
Alex:1 - Queries:0