Search results

I have developed a database on Access 2016. This is the first time one of my databases will be used by multiple users. The only problem is that the users have different versions of access installed on their computers. The versions that are installed range from 2003, 2007 and 2010. My thoughts...

Again, thank you both for your time. From what I gather I must have a table to enter the daily values, then create a query grouping it by week.

I do not have a table for every day however I created a query which calculates what the daily amounts are per day based on the MonthlyRevenu divided by days in a given month. Is it possible to do it with this query?

Ranman256, Thank you for the response. I currently do not have a [WeekEnding] field. I'm trying to create the [WeekEnding] field in a query to give me the totals. Reading back my initial post I realize I did not illustrate it properly. I have a MonthlyRevenue table that contains the month...

I am trying to calculate what my Average weekly values are based on a Monthly Value where the end of my week is Sunday. I am not sure how to go about calculating this. Any guidance would be greatly appreciated. For example: MonthlyRevenue Jun-15 - $100,000.00 Jul-15 - $125,000.00...