- 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 40 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
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
4. a. K Write a macro and create a macro button for the following: For Wealth Choice Group (ie. WCG), what is the Total
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