You can make calculation on fields of a query such as addition, subtraction, multiplication, and division.
Example1: Calculate sub total by multiplying quantity field with unit price field of TblProduct as the figure below:
Example2: You want to display Khmer currency automatically in the Khmer field when you enter Dollar currency in the Dollar field. To do that follow the figure below:
Note: If you want to display any currency that you want, format it in the Format property of the Property Sheet.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: