Crosstab: Exclude "0" values

[Cronsen]

Hello,

I have a crosstab query which gives me stock information based on a stock report from an external source.
Unfortunately, this stock report does include "0" values.


I´d like to exclude them during the crosstab query. Putting >0 as a criteria didn´t work. I received the following error message: "You can´t specify criteria on the same field for which you entered Value in the Crosstab row".
The field - to which I´d like to apply the >0 - has the "value" property (total stock).

Thanks and regards,
Mike

[Micron]

As I recall, that's a very long message that says 'remove the criteria or leave the crosstab row blank' or something like that. If you can't then consider running your CT on a select query first and eliminate what you don't want via the select query.

[Cronsen]

Thanks for the input.
Yes, it might be the easiest way to first make a simple query in order to eliminate the items.
Still, if anyone god a solution for the crosstab...

Thanks and regards,
Mike