Multiple Rows With Offer Actual Start Date Field
I have a referral report that is pulling all required data and uses Offer Actual Start Date as the prompt. Issue I'm having is if there are multiple offer attempts (only one accepted - others reneged or rescinded) and different Offer Actual Start Dates, my report is listing a row for each date instead of the last accepted date without the tentative box checked. I can't do a MAX or MIN as sometimes the actual date is before sometimes after the reneged or rescinded offer.
Is there a SQL command or other formula I can use to only pull the final offer table Offer Actual Start Date field?