Access 2010 Report asking for Parameter Value

Question

Hi,

I have a report based on a query.

On the report I have made my own text box to be used as a calculated field.

The calculation is;

=Sum([OverallAvg]+[GraphicsAvg]+[SoundAvg]+[GameAvg])/4

For some reason, this is the problem for it bringing up the parameter value, but I don't understand why?

There is noting in my query that is bringing this up.

I had a look in the Group and Sort, but there was noting obvious to look for in there?

Any help would be great, thanks!

Jack

Answer 1

So the fields in the formula are also a calculated field I made with a text box.

When referencing aggregated values in a computed control you should reference the original expressions, not the names of the computed controls in which the base values are aggregated.

Answer 2

It seems to be an easier option to do it in that, however...

When I write my formula for the calculated fields, when I go to add them to the report from 'Add Existing Fields', it says "No fields available to be added to the current view".

The only formula I added is;

Overall: Round(Avg([Overall Score]),1)

But if I take the formula out, I can use the 'Add Existing Fields' function.

Answer 3

So do you have controls on your report with those names? Frankly, I would be more inclined to do your calcs in your query rather than on the form.

Answer 4

Hi Scott,

So the fields in the formula are also a calculated field I made with a text box.

When I use the above formula to get an average of these, it comes up with a parameter box with "OverallAvg", "GraphicsAvg", "SoundAvg" and "GameAvg".

If I click on OK for them all, this sum doesn't seem to work.

Answer 5

What, exactly is it prompting for? Generally a parameter prompt means Access can't find the value you are being prompted for. Maybe a misspelling or the referenced variable is not available.