I am collecting patient information when they do not show for an apt. I've created 4 tables linked by autonum b/c I have 3 of them in a form as subforms b/c they want to be able to see everything on one screen. Each table has a date attached to it 1) data entry date 2) pt type date 3) intervention date 4) outcome date (all on diff tables). I need to create a report or multiply reports on for example: pt type = "no show" and intervention = total letters sent. reported mostly quarterly. So for Q1 (between 1/1/2006and3/31/2006) I want the total number of letters sent for all no show pts. However, in the pt type table they can become a different type of pt within the same date period for example "due/overdue" Therefore, I only want it to count the total number of letters within that quarter for "no show" and not after they have become "due/overdue". Remember this is working with two tables with a dates in each. Thank you for all your help!