Jump to content

Welcome Guest 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. Feel free to browse the site as a guest. However, you must log in to reply to existing topics or start a new topic of your own, and enjoy all this forum has to offer. Additionally, if you can assist another member by sharing your knowledge, please post a reply! Best of all - Registration and all assistance, is FREE! Learn more about How it Works. Infected? Malware Cleaning Guide. What are you waiting for?
Create an Account Login to Account

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


  • Please log in to reply

#1
MikeCorruption

MikeCorruption

    Member

  • 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

Thanks
  • 0

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


#2
dm27

dm27

    Member

  • 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.


Sincerely,

dm
  • 0


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured