Sum formula within Access

[Rania01]

Dear All,

Who can help me with a formula within Access?

Sum all [Bedrag] from [btw Code] ==> BTW Code 1
Sum all [Bedrag] from [btw Code] ==> BTW Code2

Thank you in advanced.

I use formula for the totaal
=[Q_verkooporder_regel Subformulier].[Form]![Totaal bedrag]

Thank you in advance

 

[theDBguy]

Hi. Welcome to AWF!

Not sure what your setup looks like, but have you tried creating a Totals query or using the DSum() function?

 

[mike60smart]

Dear All,

Who can help me with a formula within Access?

Sum all [Bedrag] from [btw Code] ==> BTW Code 1
Sum all [Bedrag] from [btw Code] ==> BTW Code2

Thank you in advanced.

I use formula for the totaal
=[Q_verkooporder_regel Subformulier].[Form]![Totaal bedrag]

Thank you in advance

Try a Sum If in the Subform Footer as follows:-

=Sum(IIf([BTW Code]=1,[Bedrag],0))

 

[Rania01]

Try a Sum If in the Subform Footer as follows:-

=Sum(IIf([BTW Code]=1,[Bedrag],0))

Well done Mike