Beginning Date _ Ending Date 1

[Jimmy2128]

I have a report that give the dates and the location of the annual meeting
Example of fields = (Meeting_Begining_Date) and (Meeting_Ending_Date).

The problem is if the meeting last only 1 day Meeting_Beginning_Date) and (Meetting_Ending_Date)will be the same.
What I like to accomplish..If dates are the same only show one day (Meeting_Begining_Date..

Thanks for any assistance.

Regards,

Jimmy

 

[Remou]

Hi
How about Iif?
=Iif ([Meeting_Begining_Date]=[Meeting_Ending_Date], [Meeting_Ending_Date], [Meeting_Begining_Date] & " and " & [Meeting_Ending_Date])