After 25 years, just noticed something: DSum will multiply fields

[cyberman55]

Posting this just in case others haven't noticed this. On a lark, I tried it and it worked!

Me.txtConsumeCost = DSum("[cost]*[AmountUsed]", "qryfrmProposalWiz05Sub0400Parent")

 

[theDBguy]

Hi. That's what's cool about domain aggregate functions. It won't apply aggregation until all expressions are evaluated. So...

DLookup("[FirstName] & ' ' & [LastName]",...)
DSum("[BegginingBalance]+[EndingBalance]",...)
etc.

Cheers!

 

[cyberman55]

Thanks, I was hoping someone would post more examples. Funny, I never noticed this before.

 

[theDBguy]

It's actually very handy.

 

[Minty]

Well I never knew that.

Never too old - learn something everyday - etc etc!