Report where PaidToDate < first day of next month

  • Thread starter Thread starter Song
  • Start date Start date
S

Song

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

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

Thanks.

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

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

Thanks.

Song
Click to expand...

Sorry, I mean [PaidToDate]< last day of next month.
 
I'd like to use docmd.openreport "rptMonthly",acViewPreview,,
Click to expand...
and I want [PaidToDate]< first day of next month.
Thanks.
Click to expand...

Song
Click to expand...
Click to expand...

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

<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
 
Back
Top