forms - Ms Access how to solve double row counting cause of DSum 'AND' (multiple criteria) -


i'm working dsum expression, on form. want combination results, sum of 521213 (5212213 records) each year (my choice field based). here expression:

=dsum("input";"q_rklround";"mak='521213'" , "year= '" & [form]![th] & "'") 

but expression show results of sum = 521213 records + year records instead combination. result wrong. idea how fixed it? thank you

try this:

 =dsum("input";"q_rklround";"mak='521213' , year='" & [form]![th] & "'") 

there couple of double quotes should not there.

also, year text or numerical? if numerical should use

=dsum("input";"q_rklround";"mak='521213' , year=" & [form]![th]) 

Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -