I have a query that looks like this:
Date Total Adults Total Children



I can specify 1 date or a range (September 1 or September 1-30) and it will total how many of each visited our facility that day. What I want to do now is have the columns total. That is, when I specify more than one date I want to add the number of adults for the month. I have no idea how to do this. Do I need to do this in a report rather than a query?