Hey Guys, I figured out a way around this bug, I imagine this is not a common problem since mose people probably dont put buttons on reports, but if your boss requests it (like in my case) here is a small piece of code I use to to export the report to word without the totals error we had before. This works because something about access counts does not export well unless in preview mode, figuring that out was the real breakthrough.
Code:
Private Sub ExportWord_Click()
On Error GoTo errorHandle
Dim reportName As String 'save report name for export proccess
reportName = Me.name
DoCmd.OpenReport reportName, acViewPreview 'put in preview mode to avoid totalling error
DoCmd.OutputTo acOutputReport, reportName, acFormatRTF
DoCmd.OpenReport reportName, acViewReport 'put it back in report mode
Exit_ExportWord_Click:
Exit Sub
errorHandle:
MsgBox Error$
Resume Exit_ExportWord_Click:
End Sub
If an administer sees this feel free to mark it as solved