Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

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:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP