two columns of data on one report

[genevx]

i'm trying to gather the sum of commissions from a trade table and then post them onto one report. however, the trick is, one column of sums (rows are labeled by sales trader names) is supposed to be the commission calculated for today...and the second column is the sum of the commissions for a particular date range entered by the user. How do i get both these sums onto one report? do i have to make two queries? if so, how do i make access allow me to cross the queries together? hope i was clear...and thanks in advance! =)

 

[genevx]

hmm...it still doesn't work. the problem is that i can't create a query that joins the two queries. it tells me that it can't connect the two