Hi,
i have a query made up from two other queries that count the number of goals or assists a player has scored for a hockey team.
When I try to add the two columns together using;
Total: [CountOfNumber_A1]+[CountOfNumber_A2] it will only add up the rows where there is a number on both i.e. a Goal AND an assist...it won't carry through say 4 goals and NO assists to give a total of 4 points...
Anyone help with that ?
Cheers
Darren
i have a query made up from two other queries that count the number of goals or assists a player has scored for a hockey team.
When I try to add the two columns together using;
Total: [CountOfNumber_A1]+[CountOfNumber_A2] it will only add up the rows where there is a number on both i.e. a Goal AND an assist...it won't carry through say 4 goals and NO assists to give a total of 4 points...
Anyone help with that ?
Cheers
Darren