Advertisement

08.28.2008 at 11:10AM PDT, ID: 23686595 | Points: 500
[x]
Attachment Details

DSum Function Isn't working In Query

Asked by Appealinggirl in Visual Basic Programming, SQL Query Syntax, Access Coding/Macros

Tags:

I need to make a running sum in a query but it's not working.  I have three fields that it needs to look at.

EMPLID_Sort (Text Field)
Sort_Order (Number Field)
T_Pd (Currency Field).

I have the query already set up to show only one EMPLID_Sort so I don't need to group anything.  I just need it to give me the running sum of T_PD based on the current Sort_Order and any Sort_Order prior to it.  This is how I wrote the expression DSum("[Days]","Pay_Table_Temp_Table","[Sort_Order] <= " & [Sort_Order]) but I just get an the error message "Undefined function 'DSum' in expression.

Example:
EMPLID_Sort                          Sort_Order       T_Pd      Running Total
0084765-POC      2007101      $35.00      $35.00
0084765-POC      2007102      $350.00      385.00
0084765-POC      2007103      $350.00      735.00
0084765-POC      2007201      $303.33      1,038.33
0084765-POC      2008101      $46.67      1,085.00
0084765-POC      2009111      $0.00      1,085.00
0084765-POC      2009112      $0.00      1,085.00


Start Free Trial
 
Keywords: DSum Function Isn't working In Query
Title
1 performance of Dlookup and Dsum fun…
2 WHEN REPLACED DSUM WITH TSUM -…
3 dsum function in Vb?
4 runtime error 2001 (dsum issue)
5 DSUM Criteria problem
6 Dsum help
 
Loading Advertisement...
 
[+][-]08.28.2008 at 12:24PM PDT, ID: 22338772

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.28.2008 at 09:37PM PDT, ID: 22342377

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.29.2008 at 03:15AM PDT, ID: 22343846

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.30.2008 at 10:07PM PDT, ID: 22354104

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.30.2008 at 11:19PM PDT, ID: 22354169

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628