I have a query problem that I would like some help on. I need to create a query from a transaction table. The table has ref(reference number), trd(date), trt(total), and trc(code). I can create a query that has MTD or YTD but not both at the same time. In order to get a true total I must also add up all of the totals for trc = "I" and subtract everything else. If anyone can help I would really appreciate it.