What is a calculated field and how do I create one in a Query in Access 2007? A calculated field is a field you create in a Query to mathematically calculate fields. For example, say I have two fields: Week Hours and Hourly Rate. You can create a third field in a create to calculate or multiple these two fields together and get a third field show the employees weekly pay. This third created field can be customized to show the numbers in a currency format, the title of the field and more! The calculated fields can be a great help when you need to perform those calculations without having to use a calculator. See how to create a simple calculated field with our training videos!

Purchase the training video and you can see this in action for yourself!