RELATION PROBLEM

[dridgeway]

TABLE A HAS A FIELD I'LL CALL "CHARGES"

TABLE B HAS MANY RECORDS THAT MAKE UP THE TOTAL IN TABLE A CHARGES (USES CODES, BUT COULD HAVE SAME CODE DIFFERENT DOLLAR AMOUNT)

HOW CAN I RUN A QUERY TO SEPERATE OUT EACH CODE'S CHARGES TYPE WITHOUT DUPLICATING INFORMATION IN THE REST OF THE QUERY?

 

[gol4]

see either Distinct in access help or group by clause