I have a table I have to retrieve data from for a report. The table has a field for month number(1-12) and year (2009).  I have to build a report to see the next 12 months of data from any given date.

The closest I came was

(field.year) >= Year(CurrentDate()) and (field.month) >= Month(CurrentDate());

When I run the report all I get is Dec. 2009 and Dec 2010 info, but nothing in between. I tried to add 11 to the month number, but it then goes past 12 which tells me I am doing something wrong.

* I do not have an actual date field in the table, just these two fields.

Thanks for any help.

Flanman

DBlank, very ingenious, but wouldn't you want to use day(currentdate)-1?

Thank you both. That worked like a charm. I am fairly new in a position and you all the great help I have received on this forum have really helped me out a lot.

Thanks again,

Flanman