1.Create a copy of the Shipments By Vendor query. Name the query Shipments By Vendor and Year. Open the query in Design view. Add a new field before Company Name. Extract the four-digit year from the ShippedDate field using a function and ensure the Total row is set to Group By. Name the column Year.

2. Add a new field to the Revenue query that displays Profit when the value of the Net field is greater than zero and Loss when it is less than or equal to zero. Name the field ProfitOrLoss. Run the query and ensure orders with negative Net fields display Loss. Save and close the query.

Need help with writing out these functions. I'm just looking for the formula.