Enter Parameter Value Pop-Up

[ghodgkins]

I have a query that pulls a value from a table, then I created a new field in the querie to run an equation. When I go to run the query, I get the pop-up that says "Enter Parameter Value" with the name of the field that's in my equation. If I leave it blank, it just hit enter, it runs no problem. However, it is a bit annoying and I was wondering if there is a way to prevent that pop-up from coming up every time?

[ssanfu]

There is something (variable, field) in your calculation that access cannot find - therefore access asks for a value. Check the name of the field and fix it (I would check the spelling first).

If I leave it blank, it just hit enter, it runs no problem

But does it return the correct result?

[ghodgkins]

It is giving me the correct answer. I also double checked the names, and they are correct. I even made sure I was pulling from the "list" that pops up when you start typing.

[ssanfu]

get the pop-up that says "Enter Parameter Value" with the name of the field that's in my equation

The fact that you get the pop up and a field name, means that Access can't find that field.
Without seeing the dB, that is about all I can help you with.


Out of curoisity, if you enter 1000 in the parameter request, do you still get the correct answer?

[ghodgkins]

Yes, it seems as though no matter what I put in there, number wise, it still comes out the same. If I put in an alpha charachter, everything says "#NAME?".

[ssanfu]

If you can put any number in and the result doesn't change, why is that field name in the calculation?

Review your calculation........

[ghodgkins]

Here's What I have:

FieldB: Avg([Table1]![FieldA])

FieldC: [Table2].[FieldC]

Result: Round(([FieldB]/5)*[FieldC],2)

If I take out the query field for the "Result" equation, the query will give me the other two fields. But when I enter the "Result" equation into the the third query field, that's when I get the pop-up, and it asks about "FieldB".

[June7]

Post the entire SQL statement.

I don't think can reference an aggregate field like that in the same query.

Why don't you build a report and do calcs there?

[ssanfu]

Try changing this

Result: Round(([FieldB]/5)*[FieldC],2)

to this

Result: Round((Avg([Table1]![FieldA])/5)*[FieldC],2)

[ghodgkins]

It works!! Thank you so much!!