[RESOLVED] Crystal 8.5 formula problem

[ydarb]

I am having trouble getting certain data not to show. Basically, the way the database was designed so that each time an update to a record is done, it actually inserts a new record. For instance, if person A worked on project #1 for 2 hours, and then person B finished it, there would be two records. My report should only show those projects that are not completed. So initially I tried to exclude anything that was finished, but in this case the first record still shows up on the report. Is there a way with the formula editor (or any other way) to say, if Project #1 ever = finished, don't show any Project #1 records?

thanks alot.

[ydarb]

I was able to get the desired results by changing the sql query. since the records were inserted with a date stamp, i did a max on the date so i'd only have the most recent row.