RE: [AccessDevelopers] DSum question

 

Try:
=DSum("[TimeSpent]","tblTaskDetals","[TaskUpdateDate] between #" & [txtWeekStart] & "# and #" & [txtToday] & "#")

This assumes you have two text boxes with the appropriate names and values.

Duane Hookom
MS Access MVP
To: AccessDevelopers@yahoogroups.com
From: luvmymelody@yahoo.com
Date: Fri, 27 Jul 2012 23:20:17 +0000
Subject: [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 (2)

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

.

__,_._,___