You can have the query request the dates you want to compare each time you run it, then you can have only one query and it will change each time. In the date fields put Between [[Field to query]![Beginning Date] And [Field]![Ending Date] This way it will prompt you to enter the dates. "KelMon" wrote: > I have a database that I need to calculate the differene between Period 1 > Total dated 2/5/2005 and Period 1 total dated 2/15/2005. There are many > enteries in the Period 1 Total field so I prompt for a date range to find the > difference between the two dates.