add a column in a query

[fanfan2]

Hello,

I'd like to add a new column in access query (see attached) that within the same batch if there is a "f" in the "passOrFail" column, then in a new column put a "f" for the whole batch, otherwise put a "p" for the whole batch.

Any help would be greatly appreciated.

 

[MStef]

Hello fanfan2!

Look at "DemoForPA2000.mdb" (attachment).
Look at Table1, Query1, Module1.
Run query1. I suggest make a report on query.

 

[fanfan2]

thanks so much - that's very smart solution!