ms-accessms-query

How do i add percentage an Access query?


My teacher wants us to add 10% to the net income in our query and he told me he can't help us in out projects but I don't understand how to do that?the picture shows the query I am attempting to change


Solution

  • Change it to an update query.

    For Field: put [Net Income]

    For Update To: put [Net Income] * 1.1