Hi, All - Maybe someone can help or direct me to a question that's been asked in the past.

My query calculates a project timeline based on what's driving the schedule. Option A sets a hard date for the halfway point and calculates the end date based on an assumed schedule length (x amount of weeks as defined by the user). Option B sets a hard date for the project end date and the halfway point is back-calculated.

When I run the query to sort the halfway point dates it filters out all the projects records that were selected as Option B.

1) Why does this happen?
2) How can I return all the project records on the sort?

thanks!

---

Reply from Alex Hedley:

This depends on your Query, are you able to share the SQL?