Help with report criteria expression
 

Hello!

I am trying to create a report from a query. The query is based on invoices. In my report, I want it to only show invoices between certain dates, but not all invoices.

Here is what I've entered as the criteria expression:
[InvoiceDate] =>[05/15/2013] And =<[08/10/2013]

I consistently get the error message: You may have entered a comma without a preceding value or identifier.

What am I missing?

(Obvious newbie :o)

PS....this is a fantastic site....thanks to all the experts who have passed on their knowledge!

Re: Help with report criteria expression
 

The equal signs comes before the greater than/less than symbol, and you don't put brackets around actual data. And I'm not familiar with you are putting this criteria, but generally if doing multiple comparisons you need to use the field being compared everytime:

[InvoiceDate]>=5/15/2013 AND [InvoiceDate]<=8/10/2013

Re: Help with report criteria expression
 

Dates need the ## to delimit, and I prefer the Between .. And .. Construct , which is simpler and less typo error prone than using the arithmetic notation

InvoiceDate Between #5/15/2013# And #8/10/2013#

Brian