Report where PaidToDate < first day of next month

[Song]

I'd like to use docmd.openreport "rptMonthly",acViewPreview,,

and I want [PaidToDate]< first day of next month.

Thanks.

Song

 

[Song]

I'd like to use docmd.openreport "rptMonthly",acViewPreview,,

and I want [PaidToDate]< first day of next month.

Thanks.

Song

Sorry, I mean [PaidToDate]< last day of next month.

 

[Song]

I'd like to use docmd.openreport "rptMonthly",acViewPreview,,

and I want [PaidToDate]< first day of next month.

Thanks.

Song

Sorry, I mean [PaidToDate]<= last day of next month.

 

[John W. Vinson]

I'd like to use docmd.openreport "rptMonthly",acViewPreview,,

and I want [PaidToDate]< first day of next month.

Thanks.

Song

Sorry, I mean [PaidToDate]<= last day of next month.

<chuckle>

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

will get all values up through the end of the last day of next month. Note
that this will include records from 1992 if your database goes back that
far... you may want a lower bound criterion as well.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com