[AccessDevelopers] DSum question

 

Hello all,

I have a few text boxes on the form that I was checking the sum of values in a table and I get an #Error error. Am I doing something wrong??

Thank You

Jim Wagner

Below is my expression

=DSum("[TimeSpent]","tblTaskDetals","[TaskUpdateDate] between [txtWeekStart] and [txtToday]")

I have another text box with a similar expression for another table and I do not get any #Error. Below is the expression that works,

=DSum("[TimeSpent]","tblTasks","[TaskDate] between [txtWeekStart] and [txtToday]")

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

Please zip all files prior to uploading to Files section.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___