How To Do This Expression In A Queary in Access 2007?
Posted 25 November 2011 - 02:59 AM
Posted 05 December 2011 - 06:36 PM
Have you found a solution to your problem already?
If not, give this a go. If your employee and annual pay are in the same table, use the Query wizard or Designer to bring that table into a new query.
- Drop your employee name field (and any other data you want to display) into the design grid
- In the second field you need to create an expression. For example: MonthlyPay: AnnualPay/12 (Note: AnnualPay will need to be changed to match your actual field name for the annual salary.)
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users