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 -

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

How to understand 2 main() functions after using uftrace to profile the C++ program? -