Query that shows max of 1 field and null of another

[jjake]

I have a query that has 5 fields.

TaskID
Task
StartDate
MaxofCompletionDate
DueDate


If i input a new task with a start date of 4/21/16 but it does not have a completion date yet, i will get no results. If i input a completion date into the table it will then return a result. How do i make it so the query will find results that have either a start date and no completion or the maxofcompletiondate if it has one?

 

[plog]

Can you post some sample data? Give me 2 sets:

A. Starting sample data from your table. Include table and field names and enough data to cover all cases.

B. Expected results based on A. Show me what data you expect your query to return when you feed it the data from A.

 

[jjake]

Can you post some sample data? Give me 2 sets:

A. Starting sample data from your table. Include table and field names and enough data to cover all cases.

B. Expected results based on A. Show me what data you expect your query to return when you feed it the data from A.

Table w/ linked table

Query

This is my viewable continuous form that runs from the query

This is my editable form for entering new data like a new task. At this point there will be a start date but no completion date. The highlighted entry is a new entry that will not populate on the viewable form because the completion date isn't filled in on the next form

When I got back to the viewable form and refresh it will not populate on the list because it doesn't have a completion date. which doesn't allow me to use my next form which opens by click the task

Here the user will enter a completion date once it has been done for the first time. My problem lies with the fact my first form will not display it in the continuous form so I cannot get to this point to enter the completion date.

Hopefully this is the information you require.

Thanks.

 

[plog]

Nope. I can't read your initial data (A) and you didn't provide expected results (B). You could upload a spreadsheet with the 2 sets of data, or you can type it in here using this format/layout

TableNameHere
Field1Name, Field2Name, Field3Name...
David, 12, 3/4/2016
Sally, 44, 1/19/2016