unless same as other value

  • Thread starter Thread starter Dan @BCBS
  • Start date Start date
D

Dan @BCBS

A text box in a report has this code: =[CA_DATE]+1

If this date is the same as another value (DateX) then display that value
(DateX)Another words don't add one day to CA_DATE.

Any suggestions?
 
A bit unclear on what you are asking. I think the following may be what you want.

= IIF([Ca_Date]=[DateX],[DateX],[Ca_Date]+1)

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Do the calculation in the query that is the source for the report like this --
Report_Date: IIF([DateX] = [CA_DATE], [DateX], [CA_DATE]+1)
 
Back
Top