Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-25-2013, 11:46 AM   #1
julie417
Newly Registered User
 
Join Date: Aug 2013
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
julie417 is on a distinguished road
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 )

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

julie417 is offline   Reply With Quote
Old 08-25-2013, 12:14 PM   #2
plog
Banishment Pending
 
Join Date: May 2011
Posts: 9,405
Thanks: 11
Thanked 2,282 Times in 2,234 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
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
plog is offline   Reply With Quote
Old 08-25-2013, 02:00 PM   #3
Brianwarnock
Retired
 
Brianwarnock's Avatar
 
Join Date: Jun 2003
Location: Merseyside England
Posts: 12,701
Thanks: 39
Thanked 539 Times in 521 Posts
Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light
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

__________________
What is this life if, full of care,
We have no time to stand and stare

I do not have Access these days 2015
Brianwarnock is offline   Reply With Quote
Reply

Tags
criteria expression , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
IIF Expression in criteria Monardo Queries 2 08-06-2012 02:11 PM
Data type mismatch in criteria expression - but no criteria... JamesMcS Queries 2 06-07-2010 07:23 AM
'Data type mismatch in criteria expression' - when filtering report captain1974 Reports 19 03-23-2007 03:19 PM
Using Criteria in an Expression Scottie31 Queries 1 02-15-2006 10:31 AM
criteria expression? pungentSapling General 2 09-26-2002 12:42 PM




All times are GMT -8. The time now is 01:35 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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