Date calculation

[Guest]

I want an expression to calculate "same perior previous year". For instance,
if I am using Sept.04 data in October, I want compare Sept.04 totals with
Sept.03 totals. Any suggestions.

 

[RobFMS]

How is the user selecting the Month and/or Year? Is the information selected
on a form?

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Sunny]

dToday = DATE()
dLastMonth = DATE() - DAY(DATE())
dLastYear = GOMONTH(dLastMonth,-12)