unless same as other value

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?
 
J

John Spencer

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
 
K

KARL DEWEY

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)
 
Top