Marshall Barton OR anyone Crosstab query

[Blair]

Just got your reply, Thanks worked great Mashall

Now another Question on this type of query.
depending on what sheds we use on the farm, the shed numbers are not always
the same.As the shed numbers change the results of the query and the data
sheet view will change accordingly. BUT my report made off this query will
not change automatically, I will have to manually add or delete the shed
fields in the report.
Is it possible to make a report that will display the appropriate results
according to the sheds that have data to display?
The data sheet view of the query would be great if some how the subtotal
and grandtotal rows I want to display could be written in the sql of the
crosstab query to display in the data sheet view. Is this possible?

Thanks Blair

 

[Blair]

I spoke too soon Marshall, It worked for shed 1 or column 1, but I need a
text box for each column so how do I tie this IIf statment to each shed # or
column
Thanks Blair