I am trying to perform a calculation in the middle of some text that will all be used to populate a text box on a form. Here's what I am doing. the overflow occurs on the line that starts with int45. It may be obvious to anyone that reads this code, but this is the first time I have tried something like this.
Dim int41 As Integer
Dim int42 As Integer
Dim int45 As Double
int41 = DCount("*", "SelectedVarietyWinners-Tr
ait")
int42 = DCount("*", "SelectedVarietyHeadToHead
s-Trait")
int45 = int41 / int42
Me.Text48.Value = "* There were " & [int42] & " varieties having the same trait as " & [SelectedVariety] & ". Of those varieties, " & [SelectedVariety] & " had a higher average yield in head to head tests than " & [int41] & " varieties...or " & FormatPercent([int41] / [int42], 0) & " of the varieties."
Start Free Trial
