Query criteria

Dear Emma

Thank you for attending the Access Course. I hope the course was beneficial to you!

Yes there are other calculations that you can perform other then simple AND OR queries!!

I am not sure if you have attended the Access Intermediate course or not you will or would have learnt that you can create a new field in a Query Grid box which can be used for calculating various fields.

This is how you would normally perform calculations based on other fields in Query!

Please refer to the Access file that I have uploaded with this post.

You