thanks, actually got that working with the log field. i am getting the date of a specific satus what is the formual to get the user name? can't seem to get that right. this is what i am using to get date of WIP
If(Contains([Update Status],"WIP"), ToDate(Left(Right(NotRight([Update Status],"WIP"),"["),9)),null)
i wasn't able to figure out how to do a lookup from the parent table to the status table to get the date/time of a specific status
in the report? How? I couldn't figure out how to do that, so did the summary on the table relationship
You can do multiple summaries with different criteria in the relationship?