Date manipulation

[steve]

I would like to use a date entered on a form in a query
and retrieve statistics based on that corresponding week,
month, previous month, and year. Do I have to convert
the text entered to a date field somehow and then
subtract 30 from it to get the previous month? I would
also like to retrieve the month "literal" (ie. August)
based on this "new" date. I have the week, month, and
year fields down, but the "previous" month is giving me
problems. I have tried this different ways but always
get a syntax error. Any ideas?

 

[Ken Snell]

Check out the DateAdd function and the Month function. Together, you can use
them to do what you seek! Both are described in Help file. If you need
assistance or have questions, post back!