khonaker
07-23-2018, 06:35 PM
Hello, brand new to coding and VBA. My tutor is out for the night, and I was hoping to get some friendly help with a question I have. I'm working on
Given the following code snippet, add the required statements to accumulate the sales_amt column of data and display the total to a message box with the appropriate label and formatting.
I need to write my statements below but indicate what statement# they precede or follow:
1 rst.MoveFirst
2 Do While rst.EOF = False
3 debug.print rst!CustName
4 debug.print rst!Sales_Amt
5 rst.MoveNext
6 Loop
I appreciate the help!
Given the following code snippet, add the required statements to accumulate the sales_amt column of data and display the total to a message box with the appropriate label and formatting.
I need to write my statements below but indicate what statement# they precede or follow:
1 rst.MoveFirst
2 Do While rst.EOF = False
3 debug.print rst!CustName
4 debug.print rst!Sales_Amt
5 rst.MoveNext
6 Loop
I appreciate the help!