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

[MikeCorruption]

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 query which shows the monthly salary for the members of staff, basically i already have the annual salary in the database but in the query 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

 

[jdraw]

What have you tried? What was the result? Errors?

 

[MikeCorruption]

I havent tried anything because i dont understand how to do it, basically i want to make a query and within this query i want to divide one of the fields by 12 and then have the answer displayed in a field

 

[student]

In design view, simply type:

monthly_salary: [annual]/12

where "annual" is the field name for the annual salary, and "monthly_salary" will be the field name for the results of the query.

 

[jdraw]

Watch this free video. It shows the query wizard, but goes beyond what you need.

It should help you understand setting up a query, so you can try something.
http://www.youtube.com/watch?v=K70QnTfGjoM

If not post back