Group By formatting

[westcoaststyle]

Good morning everyone! I have a question about the Group By function in my SQL statment:

Say I'm querying on apples, grapes, pears, oranges, and melons. The problem that I'm facing is that my report is showing (for example):
apples - 10
pears - 8
oranges -6


I want to see this:
apples - 10
grapes - 0
pears - 8
oranges - 6
melons - 0

I want to display those zero values, but I don't know how.

Any ideas? I tried the Nz( ) function, but I think that's for VBA and I'm not returning a null.

Thanks!

 

[jebry]

Hi!

Glad it's working!

Jeff Bridgham
bridgham@purdue.edu