Hey Guys!

I wonder if you can help! I have got a report template tool (not access) that lets me use computed fields with code much like used for excel.

I want to write a statement that looks for the minimum date (which meets a certain status) the maximum date (which meets a certain status).

I kind of want to put these statements together but not sure how!

Sum(Min (Effective date) sum(max(effective date)
If(status = 48h,1,0) if(status = ri,1,0)

Thanks

Lucy