Let( [ x = MonthName( DateStartConvert ) ; y = MonthName( DateEndConvert ) ] ;
Guest Name & " (" & Left( x ; 3 ) & " " & Day( DateStartConvert ) & "-" & If( x = y ; "" ; Left( y ; 3 ) & " " ) & Day ( DateEndConvert ) & ")" )
N.B.: This may lead to misleading results if your dates span more than one year.
This works perfectly! No worries about the dates spanning more than one year, as I am using this as a reservation database and the longest stay we normally have is 1 month. Thanks so much for your help. Greatly appreciate it!