I am trying to understand how this DCount function is working. Step by step.
I know that for technical people like you June7 it is easey but i am not seeing how this is working.
If you creating function like this you see how it is counted in your head, what results will be.
I am not seeing it
I know that DCount function is counting all pairs of Workload & isTrue field.
when we have one condition:
"[Workload] & [isTrue]='" & [Workload] & [isTrue] & "' we will get (screen in atachment).
How this AND Val(MemoryGIB)<" & Val([MemoryGIB]) will change it?
How this is working?
Best,
Jacek
When we have MemoryGib < MemoryGib. So when you have in Work1-Yes 128, 1024, 324 - dcount is comparing all of it? so checking if 128 is smaller < 324 but it is also smaller than 1024...
Best,
Jacek