Jump to content

Welcome to Geeks to Go - Register now for FREE
Geeks To Go is a helpful hub, where thousands of friendly volunteers serve up answers and support. 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. This message and all ads will be removed once you have signed in.
Create an Account Login to Account

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


Similar Topics: How To Do This Expression In A Queary in Access 2007?     x




  • 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

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On: