ms-accessms-query

Access query is asking for parameters for calculated field, how can I stop this?


I have a query set to calculate units processed per hour by user. The query returns the correct numbers when I run it, however every time that I run it , it will ask for parameters for two fields and I just click "ok".

When I link the query to a report, it will not display anything, but it does when I just open the query. What is going on ?

My query is set up as such .

The Parameters asked for are

  1. Sum Of NBR OF UNITS
  2. Sum Of DURATION

Solution

  • Column4 (if required) should be changed to:

    Expr1: [NBR OF UNITS]/[DURATION]
    

    Or, if a summation is required:

    Expr1: Sum([NBR OF UNITS]/[DURATION])
    

    You are prompted for the parameters because the aliases Sum Of NBR OF UNITS & Sum Of DURATION are not defined when the division expression is evaluated.