Crosstab queries

S

Stewart Walker

I was wondering whether it is possible to display row
headings for a group when the value element of that group
is zero e.g.

thing eggs
north 2
north 3
east 0
east 0
west 1
west 2

I would like to be able to run a query where in the above
example the 'east' row heading would appear with a total
of zero eggs next to it rather than not appearing at all.

I hope this makes some sense, and I hope someone can help!!

Stewart Walker
MOS Excel Expert (wish it was Access Expert!!)
 
D

Duane Hookom

If you have records with East in them, they will display as row headings. If
there are no East records then there will be no East column headings. You
might have East in another table that you could use but you haven't provided
enough information.
 

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

Preferred way to do sort order - column in table, or specified in query? 3
Count Numbers 4
Count Numbers 12
Loop Append Query 1
Append and Loop Code 3
Multiple criteria - count if or sumproduct? 3
Unable to get a query to count as zero if record is blank 5
Parameter Queries in Crosstab Query 2

Top