Access salary help needed

[Computer_gal]

I'm working with this access thing for my job. But I am sort of confused. I was told to..

[2009 Salary]: [Salary]*[2008Increase]+[Salary]

And then



The Bonus is based on Performance. If the Employee's performance is Excellent, they get a 5% Bonus on their 2008 Salary. If the Employee's performance is Good, then the Bonus is 2.5% on their 2008 Salary. I've given you the formula, but try building it inside Builder so you can become more familiar with the tool. It includes a nested IF and Only IF statement
Bonus: IIf([Performance]="Excellent",0.05*[Salary],IIf([Performance]="Good",0.025*[Salary],0))
3.Next, using the structure found in the formulas above, create a new field called Increase, which is the difference between the 2008 Salary and the 2009 Salary.Subtract [2008 Salary] from [2009 Salary] to perform the calculation.

I am stumped. Can anyone help me?

[June7]

Need to do calculations in query or in textboxes on form/report. The assignment has provided you the expressions to use, now put them into the query.

Review
http://www.fontstuff.com/access/acctut02.htm
http://office.microsoft.com/en-us/ac...005188027.aspx

[Computer_gal]

Okay let me try that to see if I can get it working.

[Computer_gal]

You will need to create a query with the following fields: Location, LastName, FirstName, Gender, Title, Performance, 2008 Salary, 2009 Salary, Bonus, and HireDate

^^ I have all the fields up but the 2008 and 2009 one. How do I create that?

[June7]

How do you create what? If you have the fields then you have the query built. Now build expression as per the given examples that subtracts one field from another.

If you want to provide project for analysis, follow the instructions at bottom of my post.

[Computer_gal]

Okay what I did was go to to more forms, pivotable and I click formulas then calculate detail field. I typed in both forumulas and nothing works.

[June7]

At this point, can't help unless you want to show us what you have done. I need to analyse latest efforts.

[Computer_gal]

What i've done is try to use the pivot table to calculate the fields but I keep getting "ERROR".

[June7]

I don't know how a pivot table helps do what you want. I have to see your efforts and work with data. If you do not want to provide I can't help further. I have your data from the earlier post. At least provide the SQL statements of the queries so I can replicate your efforts and analyse.

[alansidman]

http://www.access-programmers.co.uk/...=224690&page=2

Seems there is some progress on this issue at this site.

[June7]

Okay, hopefully they will resolve it over there. Computer_gal, I don't think you have been responsive to my requests. Have you even reviewed the references I provided? Building queries with calculations is basic Access functionality and there are many learning aids to demonstrate how.