Crosstab Query and Zero Values

[Guest]

Greetings, thank you in advance for looking. Basically the database tracks
spend based upon the vendor and who is spending the money. Problem is that
not all spenders spend with all vendors and vice versa.

I need to create a crosstab query that I can take out of access and paste
into a preformated excel workbook. Problem is that I can't figure out how to
create the crosstab so that all values for the Row are shown. I added a zero
spend record for all vendors with all spenders...hoping this would resolve
the situation. Alas it did not, Access isn't showing records that have zero
spend accross the board. Any suggestions would be GREATLY appreciated.

-John

 

[Michel Walsh]

Have your crosstab query in SQL view. Change your

TRANSFORM someAggregate(someField)
SELECT ...


to


TRANSFORM NZ( someAggregate(someField), 0 )
SELECT ...




Hoping it may help,
Vanderghast, Access MVP