Ihave created an Access Form to enter information about different clients I amserving through a grant funded program. The grant requires that we meet certainbenchmarks and I am at the point now where I need to create reports that showour outcomes each month. I know very little about queries or reports in Accessand do not know where to start. I need to be able to do a couple of things. Theclients in the program meet with a therapist and our grant benchmark is that eachclient meets with a therapist at least 3 times a month. My form allows a userto enter in a date and the type of therapy they had. My first question is howwould I write a query where I could generate a report that provides a list ofall of the clients with the number of therapy sessions they had in a givenmonth and also calculates the average number of times the clients as a wholemet with a therapist for the month (total therapy sessions for all clients inJanuary divided by number of clients)? My second question is a little bit morecomplex and only impacts the numbers for a client the first and last month theyare in the program. Sometimes a client may not begin the program until wellinto a month and we do not want our numbers negatively impacted by this. If wedon’t take into account the number of days someone was in the program the firstmonth they enter the program or the last month they are in the program, then wecould end up with numbers that show that we are not meeting our goals. Forexample, if client 1 enters the program on January 24, 2017 and because of thisonly has 1 therapy session in the month, we want to be able to calculate histherapy session number taking into account his entry into the program on01/24/17. When I first created an Excel spreadsheet for this data I actuallyhad a column for each month that indicated the number of days the client was inthe program for the month. Using the above example I then did a calculationthat looked like this (Total Number of Therapy Sessions/Number of Days Clientwas in the program during the month whichwould be 8 in the above example)*Total Number of Days in the Month. So, ifthe client in the example given above attended 1 therapy session in the month,the calculation would be (1/8)*31, which would equal 3.875. One of the forms Ihave has a program start date and end date and ideally I would be able to useit in doing the calculation, so that calculations done for a client in amonth/year in which they did not begin or end the program does not have to takeinto account the number of days they were in the program that month. Any helpwould be appreciated.