I have a database that will track i

[circles]

I have a database that will track individual progress on certain projects that an individual is assigned. Contained within this database are several fields such as goal, objective, project name, follwup date and the expected completion date. What I am trying to do is build a report that will list by project owner thier individual projects. The problem is I would like the projects that have no follow up date yet assigned to appeat at the end of each individual report. Is there some code that I can put into the criteria section of the query that will do this

 

[B827]

This SQL should do about what you want

SELECT Projects.IDNO, Projects.FollowUpDate, IIf(IsNull([FollowUpDate]),True,False) AS NoFollowUp
FROM Projects
ORDER BY IIf(IsNull([FollowUpDate]),True,False) DESC;

Sorting and Grouping within the report might provide a simpler solution.