Determining Month

[Samantha]

Here's the deal...

I have an Access 97 query which is dependent on a month criteria. Presently, it looks at the current month and subtracts 1 from it to get the proper reporting month.

This is a problem, since 01 (being Jan) - 1 is zero: not twelve.

What I would like to do is create a function that will determine the previous month. Does anyone have any suggestions????

Thanks,
Sam

Hi !

In the Access query, create an expression containing the date and add -30 to it. You will get the all previous months
from the query.One thing to remember is adding -30 days will give previous month.

Satya
Email: [email protected]

[wilton]

About -30. Will that work with months that have 28 days and ones that have 31 days?