I'm working in Crystal XI. I'm trying to fill empty fields from an alternative source. I have two fields "first date" and "latest date".  I need the most recent contact. If the client has only contacted us once "latest date' will be empty. How do I get the report to return "latest date" and if "latest date" is null to return "first date" Thanks, Fredoh

and while it is implied, if they are different rows then you will need some way to 'track' the values, like a shared variable

just my 2 cents