Variable number of columns in crossatb query

[Lizard]

Hi everybody,

I've a crosstab query that shows, as column heading, the different inventory "types" for a given part (e.g. invent available, in transit,...). The values in the result are then the quantities in inventory for the different types of inventory.
The problem is that, the report will show an inventory type column if there are some quantities. The number of columns in the query result will then vary from one day to another.
I can't then use the crosstab query as basis of another query.
Is there a way to get a fixed number of columns, showing all the possible inventory types, even if the quantities are null ?

Thanks.

Lizard

 

[MichaelRed]

properties, column headings. Fill in hte field names you want.

Other ways to do this, but this is easiest for the average.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[Lizard]

Thanks Michael ! Quick and simple ! I didn't know the trick.

Lizard