Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multiple criteria formula need help with

Status
Not open for further replies.
jedder18

jedder18

Technical User
Mar 4, 2013
29
US
scenario

clients who <= {@enddate}
clients have null value for @dischdate

or

clients who <= {@enddate}
client have value in @dischdate between @startdate and @enddate

I need clients who fit either scenario to show on report



Help Please!



Jedder

 
Sort by date Sort by votes
Try this:
Code: 
(
   IsNull( {YourTable.DischargeDate} ) 
AND 
   {YourTable.SomeClientDate} <= {?YourEndDateParameter}
)
OR
(
   {YourTable.SomeClientDate} <= {?YourEndDateParameter}
AND
   {YourTable.DischargeDate} in {?YourStartDateParameter} to {?YourEndDateParameter}
)


Bob Suruncle
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
588
dgillz
dgillz
T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
353
TPG_IT
T
john432
  • Locked
  • Question
Crystal Report formula (finding with key words) 1
Replies
2
Views
275
john432
john432
BradCustom
  • Locked
  • Question
Need help with setting a value to 0
Replies
0
Views
123
BradCustom
BradCustom
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
283
john432
john432

Part and Inventory Search

Sponsor

Back
Top