Dsum transactions based on account number msaccess 2003

[rudolfelizabeth]

How do you Dsum transactions in a query where the user will input via a query parameter the number of account and startdate and stopdate .
Dsum must then provide a correct running Beginning Balance <=startdate for that account

I used BeginningBalancesum("Balance","Transactions","<=[startdate]")

with no results.

 

[PWise]

Try

Dsum("Balance","Transactions","Fieldname<="&[startdate])

 

[rudolfelizabeth]

I have tried your sug. Dsum("Balance","[transactions]![startdate]<="&[startdate])

No result.

 

[dhookom]

If this is a query question, I'm not sure why you posted to the reports forum. It would help if you provided some sample records (only significant fields) and desired display in the query.

A correct expression might be something like the following but this would look at all records prior to the startdate entered at the prompt. BTW: IMHO, parameter prompts have no place in any application. Consider using controls on forms for all user interaction.

Dsum("Balance","Transactions","Fieldname<=#" & [startdate] & "#")

Duane
Hook'D on Access
MS Access MVP

 

[salvadorbs]

No one is probably going to read this as this is a post from 6 months ago. But this helped me so much i became a member, regardless of this thread being off topic.