I HAVE AN APPLICATION THAT REQUIRES THE USE OF 7 DIFFERENT CATEGORIES OF RECORDS - I WOULD LIKE TO SUMMARIZE THE 7 CATEGORIES ON THE BOTTOM OF THE REPORT. WOULD AN IFF STATEMENT SIMULAR TO THE FOLLOWING DO THE JOB? IF NOT, IS THERE ANY WAY I CAN ACCOMPLISH THIS? ALL SUGGESTIONS WOULD BE APPRECIATED.
" IIF([CATEGORY]= "1",SUM([FIELD A),0) "
" IIF([CATEGORY]= "2",SUM([FIELD B),0) "
JWJ
jozwiakj@earthlink.net
(630) 682-9878
" IIF([CATEGORY]= "1",SUM([FIELD A),0) "
" IIF([CATEGORY]= "2",SUM([FIELD B),0) "
JWJ
jozwiakj@earthlink.net
(630) 682-9878