Help with showing data that is not there

[rhett7660]

Hello..

This I think is easy, but I can't put my finger on it. I have a table of processes 12 of them. In the query I have them by date. What I want to do is to be able to show all 12 processes even if there is no info in them. I have a completed button, but if there is no info in the process the completed or not completed won't show up. The process is associated to an event. Hope this makes sense.

Any suggestions? I tried in the report to have a grouping, but if no information is present for that process it doesn't show up. I want the process to show up with or without info. So the end users can track the progress on a week by week basis.

Hopes this makes sense.

Thanks

 

[Brianwarnock]

You will need to link the table containing all 12 processes to the query in an outer join, probably need to do a groupby on the process.

Brian

 

[rhett7660]

Brian..

Thank you very much~!