Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Reports (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=10)
-   -   Help with report criteria expression (https://www.access-programmers.co.uk/forums/showthread.php?t=252490)

julie417 08-25-2013 11:46 AM

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!

plog 08-25-2013 12:14 PM

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

Brianwarnock 08-25-2013 02:00 PM

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


All times are GMT -8. The time now is 05:59 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World