Jumat, 29 Juli 2011

[MS_AccessPros] DSum question

 

Hello,

I have a form with a text box with the below expression. This expression used to work, but it seems that something has changed on it.

I am trying to get the totals of today's task hours from the main form and the subform. For some reason I can only see totals for dates that do not happen on today. So the expression works but not for today's date.

TimeSpent is on the main form
TaskUpdateDate is on the subform from the table tblTaskDetails.
Text117 is on the main form

I started with this expression but realized if there is a null there would be 0. So I tweaked the expression to the one below.

=nz(DSum("[TimeSpent]","tblTaskDetails","[TaskUpdateDate] = [Date]")+[Text117],0)

If anyone sees the problem I would appreciate the help

Thank you

Jim Wagner

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar