After 25 years, just noticed something: DSum will multiply fields (1 Viewer)

cyberman55

Registered User.
Local time
Today, 19:22
Joined
Sep 22, 2012
Messages
83
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

I’m here to help
Staff member
Local time
Today, 16:22
Joined
Oct 29, 2018
Messages
21,358
Hi. That's what's cool about domain aggregate functions. It won't apply aggregation until all expressions are evaluated. So...
Code:
DLookup("[FirstName] & ' ' & [LastName]",...)
DSum("[BegginingBalance]+[EndingBalance]",...)
etc.
Cheers!
 

cyberman55

Registered User.
Local time
Today, 19:22
Joined
Sep 22, 2012
Messages
83
Thanks, I was hoping someone would post more examples. Funny, I never noticed this before.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 16:22
Joined
Oct 29, 2018
Messages
21,358
It's actually very handy.
 

Minty

AWF VIP
Local time
Today, 23:22
Joined
Jul 26, 2013
Messages
10,355
Well I never knew that.

Never too old - learn something everyday - etc etc!
 

Users who are viewing this thread

Top Bottom