I really need help with this, I already typed the table, I just do not know how to do this part:
Use an update query with the following specifications to update fields.
1.On the Create Ribbon click on Query Design in the Queries group.
2.From the Show Table dialog box, add the Earnings table, and close the box.
3.Click on Update in the Query Type group of Query Tools ribbon.
4.Update the Commission field using an IIF function with the following parameter:
a)The decision parameter should test to see if Product Sales is great than 5000
b)Value is true should be Product Sales multiplied by .5
c)Value if false should be zero.
d)The formula should have the following appearance with or without [Product Sales!:
IIF([Earnings]![Product Sales]>5000,[Earnings]![Product Sales]*0.5,0)
5.Update the Net Income field by adding Base Salary to Commission.
6.Run the query until all fields are populated.
I understand the first part but I get lost when entering the IIF function, I click on Update in the Query Type part of the ribbon, then I enter the function into the Criteria section under the Commission. Please help me step by step, I am using Microsoft Access 2007.
And what am I supposed to put in the "Update To:" box?
again...Thank you sooo much for your help
Use an update query with the following specifications to update fields.
1.On the Create Ribbon click on Query Design in the Queries group.
2.From the Show Table dialog box, add the Earnings table, and close the box.
3.Click on Update in the Query Type group of Query Tools ribbon.
4.Update the Commission field using an IIF function with the following parameter:
a)The decision parameter should test to see if Product Sales is great than 5000
b)Value is true should be Product Sales multiplied by .5
c)Value if false should be zero.
d)The formula should have the following appearance with or without [Product Sales!:
IIF([Earnings]![Product Sales]>5000,[Earnings]![Product Sales]*0.5,0)
5.Update the Net Income field by adding Base Salary to Commission.
6.Run the query until all fields are populated.
I understand the first part but I get lost when entering the IIF function, I click on Update in the Query Type part of the ribbon, then I enter the function into the Criteria section under the Commission. Please help me step by step, I am using Microsoft Access 2007.
And what am I supposed to put in the "Update To:" box?
again...Thank you sooo much for your help
Last edited: