Jump to content

Create Account How it Works

How To Do This Expression In A Queary in Access 2007?

  • Please log in to reply




  • Member
  • PipPip
  • 20 posts
Hey guys and girls, this will most likely sound very dumb of me to ask but i am not very good with Microsoft Access, anyway i have designed a database and what i want to do is create a queary which shows the monthly salary for the members of staff, basically i already have the annual salary in the database but in the queary i basically want to divide the annual salary by 12 to get the answer for the monthly salary, how do i go about doing this calculation? i have tried google and didnt understand the tutorials :( again sorry if i sound stupid

  • 0





  • Member
  • PipPipPip
  • 272 posts
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.

  • 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.)
You can choose to sort by ascending order if you wish and the results should give you an employee's monthly pay.


  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Malware Removal How to Guides Windows 7 System Building Download Files Register welcome

Never used a forum? Learn how.