How do I create a custom Report field in Access 2007 that will perform mathematical calculations? Like multiplying one field say Hourly Rate, with another field like Weekly Hours to get the total payout for each week. Or other calculations like figuring out how to amortize a computer over three years like taking the Total Cost field and dividing it by three. It's as simple as adding the Text Box field to your Report and actually typing in the formula, or use the build button to get help building the formula. Watch our Access 2007 training videos on how to build a formula, and labeling the formula in the Label box. Our videos can help you certify too!

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