I am trying to add several data fields from SQL and input it into Excel.

I ran this command inside the SQL loop to get the total.

[VBA]

Dim NRC_Total As Integer

Begin Loop

' SQL Code to grab a field

NRC_Total = NRC_Total + Current_SQL_Field

Loop
[/VBA]

About 30 rows in, it popped that OVERFLOW error. Any suggestions?

Thanks!
Kaela