attached query date add

[tubar]

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

 

[boblarson]

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