472,143 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

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 1189
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.