How to remove (not show) columns with zeroes?

  • Thread starter Thread starter marko
  • Start date Start date
M

marko

Hi!
This query is about shoes.
I have a crosstab query with Brend,Model,Price in column heading and in the
row headinga i have sizes from 1 to 14. Now if the column with size 14 has
only zeroes, if there aren't any more shoes size 14 it still shows me that
column. I don't want that. How can i automatically hide a column if all of
it's items are zeroes?
Thanks

Marko
 
A cross-tab query has categories as YOU determine.

If you don't want to see size 14 shoes (0), you could try using a Totals
query, grouping by size.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
How to fill a for automaticly(just some boxes) 4
Show zero and not error when division by zero 5
Crosstab but if a value does not exist,it shows an error in a sub- 5
trying to read a query that has a variable amount of output fields 1
Filling in null values in table 1
Comparing Query Results in two columns 4
Crosstab Qry-Add Rows & Columns 2

Back
Top