Yes Sir!
OK, very simply DB that i built with some help from this forum. it is tracking change requests from the first form and the second form filters out the ones that have not been completed, the adjuster completed the request and puts there name to it, they click save and an email is generated and sent to the original requester.
The report that they are asking for is based on the "work completed by" column. what they want is a clean looking report that lists each adjuster's name if the first column, the total number of requests that they completed in the second column followed by the total number of requests in the DB and follow that by the percentage that they completed.
They are also asking for the ability to chose a date range for this report and a pie chart that shows the total amount of requests and each adjuster would be a slice of the pie in a different color.
Like I said, I can do this in Excel by using =countif arguments and making a pie chart. but it would be nice to be able to have access do this for me. I started to make a report, but the first issue that i am running into is instead of saying the adjusters name once followed by a count of the records, it is listing the adjusters name 37 times followed by the number 37, another 37 times. I am including two pictures, the first one is what I am getting from the report that I don't know how to change and the second is rather what I am wanting.
Not sure if this can be done.....I sure hope so.
The other request, is for the user to be able to adjust the parameters of the report, like a start and end date that this report would prompt for.
I learned how to write some very simple VBA code for my output email, but after that i believe that i know just about nothing in Access.