Before I'm able to answer this question, how are you computing the overall production, and how is that displayed?
And what percentage are you looking to find, the difference between last months and this months?
Let me know,
Joe P.
Hey Joe P.
Thanks for your help.
I am running a query that puts together 2 tables both have about 10 fields that has there total loans/ calls/ hours they worked/ etc (total accumulation for the entire month)...this is then multiplied by the second table for the amount of points weighted for each of the same fields joined by the date field. Then in my query it gives me calls/hour and Production % for that month (which is the total loans/calls etc divided by the hours worked for the month).
Then I put together a report that shows this individuals totals for that month ie Decembers Production % and call/hour. I am running a Parameter on my query from a Form called Reports. This runs the report by that date, ie put in 12/1/2007 it will run december Production Report. I am trying to figure out if I am running the report by ie December Production for the month that it will pull in Novembers Production% as well.
Most of the formulas I have seen use todays date and have to go back to that specific month to get it to work. But then I would have to change my formula everytime I needed to go back a few months.
If you know of anyway of doing this or a better way it would be of great help and appreciation.
Thanks