in the query criteria box, can you do more formulae than just AND or IF?

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’ll notice that the name of the database is Query calculations. In this Database there is a table called Order Details and I have created a Query called Sales_Query which has an extra field called Sales created by multiplying two fields.

I followed these steps to get the results:

Step 1: In Query design view I dragged and dropped all the relevant fields that I wanted in my query onto the grid box.
Step 2: On the grid box I clicked on the empty field and typed:
Sales: [UnitPrice]*[Quantity]
Sales is the name of the new field. The names of the fields are entered in square brackets [ ]
Step 3:In Query Datasheet view all the records show the new field where the Unit Price is multiplied by the Quanity.

I hope this helps.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please as the question as a separate posting.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003

Attached files...

Query caluclations.mdb