Dsum

  • Thread starter Thread starter Frank Dulk
  • Start date Start date
F

Frank Dulk

As would make that comparison in a query

Accumulated:dsum ("Valtot" ;"table";"DateRec <=DateRec")

In that way this giving mistake.

DateRec is a field it dates.
 
Since you aren't giving any more information, try:
Accumulated:dsum ("Valtot" ;"table";"DateRec <=#" & DateRec & "#")
 
I am using that expression to create an accumulated field, but I didn't have
success, because repeated dates exist.
 
Add another field comparison in the where clause that compares unique field
values such as the primary key in the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Minus today 2
Need this year and last year records 2
IIf statements 6
Date Validation 1
Need help on Treeview code 6
query output problem 1
Last functions in Total Row 5
What is wrong w/ this query? 3

Back
Top