Hi,
I have a query named “PSAET” with those fields and values:
I need to add a new calculated field named “ETAD” which will accumulate the ETD field and the result should be like this:
To do this, I created a new query and if I have only one batch, my formula is working fine:
ETAD: DSum("ETD","PSAET","[ON] <= " & [ON])
In reality, I have more batches so to calculate the ETAD I tried this formula, but doesn’t work:
ETAD: DSum("ETD","PSAET","[ON] <= " & [ON] And "[Batch No] = '" & [Batch No] & "'")
I don’t know what is wrong, so please can you help me?
Thank you!
I have a query named “PSAET” with those fields and values:
I need to add a new calculated field named “ETAD” which will accumulate the ETD field and the result should be like this:
To do this, I created a new query and if I have only one batch, my formula is working fine:
ETAD: DSum("ETD","PSAET","[ON] <= " & [ON])
In reality, I have more batches so to calculate the ETAD I tried this formula, but doesn’t work:
ETAD: DSum("ETD","PSAET","[ON] <= " & [ON] And "[Batch No] = '" & [Batch No] & "'")
I don’t know what is wrong, so please can you help me?
Thank you!