Search results

Thank you.......I have been trying to make this work for like 2 days. Thanks again!!

I should also state that with the above code I go the txtBox to display the first value, but it didn't change for each department.

Well, I figured that it should be called this way because the report is divided by department. So for each department name there will be a different total.

I am getting data from a query that shows how much a department spent for the year. In another table there is a projected about for the year. In a report I would like the projected amount to be subtracted from the actual amount spent.... Having a little trouble with my dlookup function...