I have two tables that are joined and I am trying to get a correct summary for 3 different fields, but my totals are way out of wack. Here is what is what I mean:
Table1 -
AccountID, Numfield1
Table2
AccountID, Numfield2, Numfield3

when I try to group by the AccountID and summarize I get this:

Account ID               Field1           Field2           Field3
1111                         5                     20                30
1111                         10                   20                30       
1111                          5                     10                 8          
1111                          10                   10                 8
1111                         5                      0                  25
1111                         10                    0                  25

Totals now               45                   60                 126

Should be                  15                    30               63              

If I do a summary with only either of just one table I get my summaries fine,
but when I add the second table the summaries double as does my total number of records. How can I setup the summaries to work correctly?

Thanks,

Flanman

Are you looking for a field that is only in table two ? Obviously the AccountID is in both tables. There is a field (ShiftID) that is only in table two that would be shared by the field 2 and field 3.

Bill