Thanks
How To Do This Expression In A Queary in Access 2007?
Started by
MikeCorruption
, Nov 25 2011 02:59 AM
#1
Posted 25 November 2011 - 02:59 AM
Thanks
#2
Posted 05 December 2011 - 06:36 PM
Hello MikeCorruption,
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.
Sincerely,
dm
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.)
Sincerely,
dm
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users