 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2008How do i calculate a field ?
I have a problem calculating fields The question said Create a query that will create a new field that will calculate an amount. The new amount is 7 % of current salary? Ok the fields I have are Employee number , employee name, date hired, dependents, Currency salary, and dept. what the correct way to calculate 7 % of current salary? and the field should be named Bonus paid Is this a homework assignment? Regards Jeff Boyce Microsoft Office/Access MVP >I have a problem calculating fields The question said Create a query > that will create a new field that will calculate an amount. The new [quoted text clipped - 7 lines] > field > should be named Bonus paid yes its a home work assignment > Is this a homework assignment? > [quoted text clipped - 14 lines] > > field > > should be named Bonus paid > yes its a home work > assignment [quoted text clipped - 17 lines] >>> field >>> should be named Bonus paid You should have paid more attention in math class. This is simple math. How would you compute the new amount using pencil and paper? Then use the same formula in an Access query. If this is a homework assignment, then the proper place to get help is from your instructor. That's what he gets paid for.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail So you're asking us to do your homework? Regards Jeff Boyce Microsoft Office/Access MVP > yes its a home work > assignment [quoted text clipped - 18 lines] >> > field >> > should be named Bonus paid >I have a problem calculating fields The question said Create a query >that will create a new field that will calculate an amount. The new amount [quoted text clipped - 5 lines] >what the correct way to calculate 7 % of current salary? and the field >should be named Bonus paid Use a query with an appropriate expression. For a more detailed answer... study your course materials. SignatureJohn W. Vinson [MVP] hi blue3509, have you find out the way? you create a query, then put Employee number , employee name, date hired, dependents, Currency salary, and dept, then type this Bonus:([Currency salary]*1.07) after the dept field. hope this answer can help you. > I have a problem calculating fields The question said Create a query > that will create a new field that will calculate an amount. The new amount [quoted text clipped - 5 lines] > what the correct way to calculate 7 % of current salary? and the field > should be named Bonus paid |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.