sql select between date range

hi
well i have a table that store the date of selling, price,area, State Name,city Name ... , I have created a query which is Called QMain and i have created a calculated field which is M2:[Price]/[Area].
Now i wan to find the M2 from old date - New Date and grouped by state name
for example :

Colorado  [New M2]- [Old M2]  = Diff
Utah         [New M2]- [Old M2]  = Diff

The date range is inputed from a form  which is set a a criteria of the query As Following:
Between [Forms]![FSalesStock]![ReportDateStart] and [Forms]![FSalesStock]![ReportDateEnd]

So, what is the best way off doing it .. is it by using sql statement or by creating two Query's one for the new date and on for the old date ..
I am open for any suggestion
thanks  Start Free Trial