Jump to content

Free help from tech experts
Welcome to Geeks to Go forums. Create an account now to gain access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing topics, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. Best of all, registration and all assistance is 100% free! This message, and all ads will be removed once you have signed in.
Sign In Create 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
  • 270 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