Working Days

I try to do the same but not got it work?

I put next formula in my query:

TotalDays: Work_Days([begdate]-[enddate])

What is wrong with this formula?

Herman
"Ian Tranter" wrote in message
...
Steve
Thanks for the advice, Things look different after a good
brake & a nice cup of coffee.
I have re looked at my query & you are correct.
I inadvertently place the count aggregate function on the
total line under the date complete field hence my work
day's function had no date to compare.
I have re done the queries & all works fine!! :-)))))

Try use a comma:
TotalDays: Work_Days([begdate], [enddate])


--
Duane Hookom
MS Access MVP


"hermie" wrote in message
...
I try to do the same but not got it work?

I put next formula in my query:

TotalDays: Work_Days([begdate]-[enddate])

What is wrong with this formula?

Herman
"Ian Tranter" wrote in message
...
Steve
Thanks for the advice, Things look different after a good
brake & a nice cup of coffee.
I have re looked at my query & you are correct.
I inadvertently place the count aggregate function on the
total line under the date complete field hence my work
day's function had no date to compare.
I have re done the queries & all works fine!! :-)))))