Hi,
I have 2 tables. One hold header info .... like nameID (primary key) name, address, country.
The second table holds donor info: nameID (primarykey), amt, etc......
I QUERY these 2 tables linking by "Name ID" to get the following data:
NameID Name Country Amt
When I DO NOT do the "Group BY", I get the correct data.
When I hit "Group By" and Make Amt = "Sum by" and rest "group by" ..... some of the data gets "DOUBLE COUNTED".
Pls. help.
I have 2 tables. One hold header info .... like nameID (primary key) name, address, country.
The second table holds donor info: nameID (primarykey), amt, etc......
I QUERY these 2 tables linking by "Name ID" to get the following data:
NameID Name Country Amt
When I DO NOT do the "Group BY", I get the correct data.
When I hit "Group By" and Make Amt = "Sum by" and rest "group by" ..... some of the data gets "DOUBLE COUNTED".
Pls. help.