ContributionsMost RecentMost LikesSolutionsRe: Combine values into new field with count Thank you so much!!! ------------------------------ Stephanie B ------------------------------ Combine values into new field with count We have way too many statuses. I want to combine several status values together to create an "In Progress" count of records so that I can have a cleaner summary table that doesn't show all of the statuses. I am pretty new to all of this so hoping someone can help me out. Example of COMPLETED status might contain the following values: Accepted Sent Completed Then I would like to display an NEW, CANCELLED, IN PROGRESS, COMPLETED summary report that is nicer to look at than the 30 statuses we currently have. Any help appreciated! ------------------------------ Stephanie B ------------------------------ Re: Trying to retrieve last comment from Audit History Mark - You are a God amongst mere mortals. I appreciate your help!!! ------------------------------ Stephanie B ------------------------------ Trying to retrieve last comment from Audit History Help! I'm trying to retrieve the last comment on a table, but I am ending up with the one above the last one. Any help would be greatly appreciated! Example of field (comments): [MAR-03-23 11:21 AM Crystal] Updated Screener [MAR-03-23 11:22 AM Crystal] . [MAR-03-23 1:35 PM Nicole ] confirmed approval, MILITARY LEASE - used LES for POI [MAR-04-23 12:45 PM Megan Botti] Added MID + Concession Expected: [MAR-04-23 12:45 PM Megan Botti] Added MID + Concession) but it is returning the one aove it Returned: [MAR-03-23 1:35 PM Nicole ] confirmed approval, MILITARY LEASE - used LES for POI FORMULA If(Trim([Comments])<>"", "[" & Right(NotRight([Comments],"["),"[")) ------------------------------ Stephanie Bouldin ------------------------------