Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Two Statement Questions Post Reply Post New Topic
Author Message
aristeff
Newbie
Newbie


Joined: 09 Feb 2011
Online Status: Offline
Posts: 6
Quote aristeff Replybullet Topic: Two Statement Questions
     Posted: 10 Mar 2011 at 4:30am
What does the following statment translate to in terms of how many days?
if DayOfWeek(today())= 2 then {PURCHORDER.PO_DATE} in ((today()-6) to (today()-3))
 
Also, could you use the statement below in an access query?
{POLINE.QUANTITY} > {POLINE.REC_QTY} + {POLINE.CXL_QTY}
 
I seemed to inherite some reports and I need some more understanding.
 
Thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 10 Mar 2011 at 7:44am
if would seem to say that if today is monday, then look at PO dated from last Tuesday to Last Friday
 
As to the second question, what do you mean by an access query?  A query in an Access Database or a query to retrieve some data?
 
Since I don't know what the values mean, it is hard to know if it is logically valid, but it is valid syntax.
 
HTH
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.