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