Error 3075 Syntax Error 1

[Garridon]

I'm trying to select records based on the last thirty days from today's date versus the date the record was closed, but I keep getting an Error 3075 Syntax Error.

This is the expression:

DCount(&quot;dateClosed&quot;,&quot;qselClosedTrends&quot;,&quot;[dateClosedJ62]<#&quot; & Date()-30)

I'm stumped! Any help would be appreciated. Thanks!
Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[jitter]

Try:

DCount(&quot;dateClosed&quot;,&quot;qselClosedTrends&quot;,&quot;[dateClosedJ62]<#&quot; & Date()-30 & &quot;#&quot

I think that will fix it.

 

[Garridon]

Thanks! That did it!

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com