ConcatRelated Error: "Error 3061: Too few parameters. Expected 3" (1 Viewer)

theDBguy

I’m here to help
Staff member
Local time
Today, 03:13
Joined
Oct 29, 2018
Messages
21,358
@theDBguy would we be able to remove the AvgPass calculation from the VBA update events? I was curious if we did this then the scores would default back to the recordsource of the form which originally displayed the correct scores.

I tried removing them but got a Run-time error '3141': SELECT statement includes a reserved word or misspelled word, or punctuation is incorrect --> and then this is highlighted in the VBA: Me.RecordSource = strSQL

Thoughts?
Hi. When you are trying to change what is being displayed on a form, you either change the Record Source or Requery it. Either way, it will still take time for Access to fetch/calculate the data to display. So, I think, even if you remove the Avg() calculation from the code (by the way, I don't think you can), then I don't think it will give you any benefit you may be thinking of gaining by removing it.

The "correct" score should display no matter what. If not, you'll have to double-check the calculation and the data set used for the calculation.
 

Users who are viewing this thread

Top Bottom