simple results required

[rehanemis]

Hi,

I have an table and would like to take the results as follows:

Table:

ProjectName cost Balance ProjectStatus
ABC 8 8 opened
abc 9 2 production
cd 9 4 closed
cd 9 4 closed
mn 3 3 opened

the result required
ABC 17 10 Open(show open when Opened or production)
mn 3 3 open

closed status not included.

Please let me know if you have any question.

Thanks

 

[plog]

That's a simple totals query: https://support.office.com/en-za/ar...-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a

Give that link a read and post back any issues you have.