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