Grouping problem with MinDate

[qlan]

Hi,

I have tblProjects and tblStatus. Under tblStatus, the same project# shows multiple times since there are more than 1 statuses entered. Please see below

Proj# StatusDate EmployeeName
8170JC 03-Jan-06 Web
8170JC 04-Jan-06 ABC
8170JC 09-Jan-06 CDE

8176DG 06-Jan-06 Web
8176DG 06-Jan-06 ABC
8176DG 09-Jan-06 CDE

8194DD 13-Jan-06 ABC
8194DD 16-Jan-06 CDE

On the report, I want to show distinct project# and the Minimum (StatusDate) but I don't want to count where EmployeeName = Web. Therefore, I have the formula: If {tblStatus.EmployeeName} <> "Web" Then
({tblStatus.EnteredDate}). I name this formula, StatusDate. I then group the report by Projectnum. Order the StatusDate "Ascending".

Because of this, my project# 8170JC,8176DG show nothing under StatusDate. Project 8194DD shows StatusDate 13-Jan-06. What should I do to have it show 8170JC - 04-Jan-06; 8176DG - 06-Jan-06 and 8194DD - 13-Jan-06. Thanks so much

 

[synapsevampire]

Try a differebt approach.

Group by the project, and in the Report->SElection Formula-Record place:

{tblStatus.EmployeeName} <> "Web"

Then in the Report->Selection Formula-Group place:

{tblStatus.EnteredDate} = minimum({tblStatus.EnteredDate},{tblStatus.Proj#})

-k