Two different dates

[mitch05d]

I have a report that runs off query in question. The report has a title that reads "end date".



I'm trying to get my query to display one entry from either "original contract end date" or "renewed contract end date".

The query as of now reads- End Date: DateAdd("yyyy",[Length],[OriginaBeginDate])

Length is contract Length in years
Original Begin Date easy enough date contract began.

So in conclusion the report needs to show either "original end date" or "renewed end date" but not both. I've tried putting in more criteria but can't get it right. Please help solve.

[JoeM]

I am finding your question a bit confusing. Can you post some sample data and walk us through an actual example of what you are trying to do?

[pbaldy]

FYI, I deleted your duplicate thread. There's no need to post the same question in multiple forums.