Page 1 of 1
4. a. K Write a macro and create a macro button for the following: For Wealth Choice Group (ie. WCG), what is the Total
Posted: Fri May 20, 2022 4:44 pm
by answerhappygod
- 4 A K Write A Macro And Create A Macro Button For The Following For Wealth Choice Group Ie Wcg What Is The Total 1 (25.83 KiB) Viewed 42 times
4. a. K Write a macro and create a macro button for the following: For Wealth Choice Group (ie. WCG), what is the Total 'average yearly sales" from Texas (i.e. TX) Pub that are were established before 1989? Present your answer in Queries sheet. b. Repeat step a, but this time, let the user enter the state. If the function returns an error (e.g. Div/O), display a message saying "No sales for the given state", otherwise, display the average. 29