Parameter Error on Calculated Field (Not typo or "visible" problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello: when running a select query containing a field dependent on a
calculated field (which is also "housed" in the same query), I am getting a
parameter popup. I have double-checked the spelling and even changed the
field name & copy/pasted in all appropriate places. I know from seeing this
before that if I can put the calculated field in one of the source queries,
this parameter error will go away. Only thing is, not able to do this now
due to the joins I need--would rather not create another layer just to handle
this single calculation. Is there a patch or something else that will
address this? Per Help, it should work so long as the calc'd field is made
visible, which it is. Why does this occur?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prompting for a parameter in a query when one isnt present 2
Sort on a calculated field 1
Aggregate calculations on calculated query fields? 6
Query Calculation using a [Sum of ....] field 3
formula requires parameter in error 2
Count text values in a Access Field 0
Overflow error on calculate field in query - Help Please 1
Creating an update query that uses multiple parameters 2

Back
Top