take a look at this DB...i have a "last" date field and a query that adds months to that field to create a new field called "next"...in the query when i do a between criteria it wont pull the proper records...example start date 1/1/09 end date 12/30/09..it should show all records for 2009..it doesnt

HELP

See attached. You have to remove the criteria from Query1 on the calculated field and then you use Query2 to get the data.