T
Tandy
Hello Everyone!
I have a field in my query called Date. Under criteria I currently have
"Between [Type Start Date] And [Type End Date]" However, I would like the
End Date to just be calculated based on the Start Date. For example, if the
Start Date is 1/1/2007, I want the query to calculate the end date as the end
of that month, 1/31/2006. I would also like another formula to calculate the
end of the month six months for the start date. So for 1/1/2007, the end
date would June 30, 2007. Does anyone know a simple way to do this?
Thank you!!!!
Tandy
I have a field in my query called Date. Under criteria I currently have
"Between [Type Start Date] And [Type End Date]" However, I would like the
End Date to just be calculated based on the Start Date. For example, if the
Start Date is 1/1/2007, I want the query to calculate the end date as the end
of that month, 1/31/2006. I would also like another formula to calculate the
end of the month six months for the start date. So for 1/1/2007, the end
date would June 30, 2007. Does anyone know a simple way to do this?
Thank you!!!!
Tandy