SELECT LAST MONTH ONLY

[grom71]

Hi all,
I think this is an easy one but I've confused myself...
All I want to do is run the report for the last month only using the month field NOT a date field as the report will run quicker by this method.
The month field is a link field called lnkmon and is a number basing on financial year starting in April.
e.g 04=April 05=May 06=June up to the following March=15

All I want is to do is run the report for the last full month only.
Can anyone help ????
Thanks in eager anticipation
Grom

 

[bdreed35]

tilakrajsingh-

If you read the requirement in the first post you will see why this was more complicated that just selecting the previous month number.

~Brian