what is the correct code for the following Dsum

[rudolfelizabeth]

I have a database with a transaction file with clients by accountNumber, startdate, stopdate, Balance,

What is the correct dsum code in the query to get the Balance of all transactions per account before the startdate
I have tried Dsum("Balance","Transactions","[transaction]![startdate]<="&[startdate])
the query has parameter to ask for which accountnumber,
followed by startdate,stopdate.

query control groupby.

No results

 

[dhookom]

I believe this is a continuation of a thread started in the Reports forum.

How about providing the SQL view of your query? Your statement "query control groupby" has no meaning to anyone except you.

I believe I asked if you could provide some additional details in the other thread. Are you willing to do so?

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

What is the whole SQL code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886