Help with report criteria expression (1 Viewer)

julie417

New member
Local time
Today, 13:08
Joined
Aug 24, 2013
Messages
7
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 :eek:)

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

plog

Banishment Pending
Local time
Today, 13:08
Joined
May 11, 2011
Messages
11,611
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
 

Brianwarnock

Retired
Local time
Today, 18:08
Joined
Jun 2, 2003
Messages
12,701
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
 

Users who are viewing this thread

Top Bottom