How to make Report omitting "Done" jobs?

[SHogan]

This is my first ACCESS project so be gentle.



I made a Table that outputs to a Report that sorts by the "Next Deadline"
What I need help with is: I need the report to omit (not show) any job that has the Phase value of "Done"

I've attached my file.
Any help would be totally appreciated as I have almost no Excel/Access experience and need to impress my new Boss.

[RuralGuy]

Have you used the Query builders to create a query that will return just the records you want yet?

[SHogan]

No, I just used the Wizard to get the report showing the sorted Table. Like I said I'm really green but appreciate any help.

[RuralGuy]

Play with the Query wizard. When you get the recordset you want then you can make it the RecordSource of the Report.

[Alex Motilal]

In the Record source of the report, Remove Table1 and past this SQL:

SELECT Table1.ID, Table1.[Project Name], Table1.Client, Table1.Market, Table1.Phase, Table1.[Next Deadline], Table1.[Due Date], Table1.PM, Table1.[Job Number] FROM Table1 WHERE (((Table1.Phase)<>"Done"));

Alex

[SHogan]

In the Record source of the report, Remove Table1 and past this SQL:

SELECT Table1.ID, Table1.[Project Name], Table1.Client, Table1.Market, Table1.Phase, Table1.[Next Deadline], Table1.[Due Date], Table1.PM, Table1.[Job Number] FROM Table1 WHERE (((Table1.Phase)<>"Done"));

Alex

Thank you SO much Alex! I am so new at ACCESS and you have been of great help with that one line. If you need any AUTOCAD help I'm your guy.

Sean

[Alex Motilal]

Thank you SO much Alex! I am so new at ACCESS and you have been of great help with that one line. If you need any AUTOCAD help I'm your guy.

Happy that I could help you. I think you can mark this thread 'Solved'.

Alex