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?
 
Are you sorting or grouping? Is this an Aggregate (sum) query?
 
You must log in or register to reply here.

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
Count text values in a Access Field 0
Query Calculation using a [Sum of ....] field 3
formula requires parameter in error 2
Overflow error on calculate field in query - Help Please 1
Creating an update query that uses multiple parameters 2

Back
Top