date expression question

[Slez via AccessMonster.com]

What kind of expression in the criteria of a date field would accomplish this?


I'd like to return related records of a date field where the value is greater
than the current month. I am generating a sales forecast, and I don't want
to display this month, but I do want to display next month and beyond.

Thanks
Slez

 

[John Spencer]

The following expression gives you the first day of the next month

DateSerial(Year(Date()),Month(Date())+1, 1)

So, in a query
Field: [Your Date Field]
Table: [Your Table]
Criteria: > = DateSerial(Year(Date()),Month(Date())+1, 1)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..