Create an update query in design view to update the following fields in the InvB table.
Update the Status field using an IIf function with the following paralmeters.
The decision parameter should test to see if Spent is greater than 2000
The value if true parameter should be "Major"
Value if false parameter should be an IIf function should test to see if Spent is greater than 1000
the value if true parameter should be "Mid-Range"
The value if false parameter should be "Minor"