William,

Thanks for your help. I will try this example and tell you.

But a quick question is I don't think there is a difference between existing query and your query because mandayperdistrictpermonth is a view in sql server and a table in Access. The query which I sent is a query applied on the mandayperdistrictpermonth. I directly given the two functions in query and you just used parameterized query which again takes the value of the same functions. I don't think there will be a difference in performance.

Any way, I will try and tell you.