Naomi,

Thanks for the reply. So simple! For some reason, I thought you had to have the 'GROUP BY' clause when using the 'SUM' command.