Code Error - Can you have too many expressions?

[aaron.irvine]

Yeah I reckon I could do that ItsMe, but in all honesty I could run it without the OVERALL totals - it's probably the least significant of all of the totals that I need to calculate. The amount of time and effort that everyone is putting into it doesn't justify the outcome, so unless it's something you really want to see through to the end, I'd be happy to leave it out completely.



Creating date filters that I can embed into buttons is more of a priority for me now, though even that I can do manually if need be.

I'm starting to drown in data entry from this project, so I need to pick and choose how much time I put into the development of it!

Let me know if you're happy to let it go, or if you want to nut it out - either way thanks a heap for all your help ItsMe and June7!!

[ItsMe]

Try this. If all you need is the average of two fields and rounded to thousandths....

Dim dblAvg As Double
dblAvg = Me.QC_ONLY.Value + Me.SIG_ONLY.Value / 2
dblAvg = Round(dblAvg, 2)

[aaron.irvine]

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)
Dim dblAvg As Double
dblAvg = (Me.QCavgScore.Value + Me.SigAvgScore.Value) / 2
Me.OverallAvgScore.Value = Round(dblAvg, 2)
End Sub

Also returned a blank.....

[ItsMe]

I copied your code into a blank mdb file that has a table, query, and report. I created some controls with names like yours. Everything worked without a hitch. Created an accdb file. Imported the table and query. Used the wizard and created a new report within the accdb. I got the same results as you. Blank control.
.
ReportSample.zip

I will look into why this is not working in the accdb. Reports in newer versions are new to me....

EDIT: works in Print Preview mode

[ItsMe]

The format event does not fire unless you are in print preview. You can place the code in the Report's load event.

Sorry about that. I have been using the format event for many years and am just now starting to understand these new fangled reports.