469,325 Members | 1,586 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,325 developers. It's quick & easy.

Average results for an Access query once ran

i have an access database with particularly 3 months representing quarters of the year( ex. October, November, December). I made a simple query, once I place my data in each month which are percentages I have the 3 months results in an average amount format via my query. (ex. October + November + December /divided by 3)

How do I make the average show all the time in my results once I run the query even though I may have only 2 months completed at any given time (i want the average to alway show).
In other words if I have data in 2 of the months and nothing for the 3rd month, I still want the average to show. Is there a sql statement i can use or an Access criteria statement I could enter in the query?

thank you
Dec 19 '11 #1

✓ answered by Rabbit

I'm guessing when it's not filled out, it's a null. Use the Nz function to change that null to a 0.

3 1149
Rabbit
12,516 Expert Mod 8TB
I'm guessing when it's not filled out, it's a null. Use the Nz function to change that null to a 0.
Dec 19 '11 #2
Thanks Rabbit, I'll try it.
Dec 20 '11 #3
Killer42
8,435 Expert 8TB
So how did it go, any luck?
Dec 23 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Kent Eilers | last post: by
2 posts views Thread by green fox | last post: by
4 posts views Thread by douglaswade | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.