First Timer attempt at Project List

[SHogan]

I created my first database/report for our office Project list:
Next Deadline, Job #, Name, Phase, Client, PM

The Report is sorted by Next Deadline. I'm fine up to there...

What I need to ask for help with is, how do I omit all records in the Field Phase that are "Done"? (Phase can be SD, DD, CD, or DONE)

Any advice would be greatly appreciated.

[jzwp11]

Welcome to the forum!

Next Deadline, Job #, Name, Phase, Client, PM

First, if the above are the actual field names in your table, it is generally recommended to not have spaces or special characters in your table or field names. I see you have spaces & #. Also the word "name" is a reserved word in Access and also should not be used as a table or field name. This site has a list of reserved words.

Now as to your question. You will have to create a query based on your project table and add some criteria for the Phase field. Since you want all projects that are not done, the criteria would be

<>"DONE"

The SQL view would look like this

SELECT fieldnames
FROM projecttablename
WHERE phase<>"DONE"

You would then change the record source from the table to the query.

[SHogan]

Thanks for the quick response. I will try it this afternoon.

[jzwp11]

OK, post back if you have any questions.