I need to create a report which shows on the same line for a salesperson for: 1) total current month's sales and 2) total of "year to date" sales previous to current month (previous months). The table where the data resides has the following fields for each record: "Date";"Salesperson";"DailySales". I consider myself an "advanced beginner" with Access. The 2 totals need to be on the same line. I know how to get them on 2 separate lines (Union Query). Please explain in "as simple of terms as possible".