Firstly, I am an extreme rookie when it comes to access. I have developed a report(revenue information) and sub-form(expense information). My expense total is correct but I want this number to appear on the revenue/expense summary along with revenue information in the parent report. I have the revenue report pulling the number from the sub-form but when I run the report/sub-report the expense number is adding all the expenses not just in a date range that I specify for the report. I am a bit confused as I need a date range for the revenue information which is working and then I have applied the same date range to the expense information and then I have a qry to calculate correct totals for both reports and I have a date range here. Obviously, doing something not right nor efficient if I have to have a user input 3 date ranges. I would appreciate it if you could steer me to lessons or seminars that might assist with direction on how to apply one date range criteria to multiple tables/queries. I have a revenue table and expense table. I need to have the date criteria (user input) apply to both tables/qrys. Any assistance is appreciated. Hopefully this makes some sense. Regards, Jim