Prompt for value of field with calculated field?

[Infiltrator64]

I have a calculated field in a query that devides one field by another in the same query. when i run the query it prompys me for Total Swaps and again for Total cases. If i just click OK it runs the query and calculates correctly.

How can i stop the prompt for values of these fields and just run the query and calculate? My code is below and all fields referenced are in the same query as the calcualted field.

Swap %: ([Total Swaps]/[Total Cases])

 

[Joe4]

Try only use alphanumeric characters in the field name (no spaces or symbols like "%").

If that doesn't make a difference, try adding table references to your field names, i.e.

Swap_Percent: ([Table1]![Total Swaps]/[Table1]![Total Cases])

 

[Norie]

Are you sure you have the field names right?

As far as I know this sort of thing would only happen if you had incorrect field names.

One good way of making sure you have the correct field names when creating an expression is to use the Expression Builder.

You can access this when in query design view by right clicking and selecting Build...

 

[Corticus]

It's prompting you because there are no fields available in the tables that comprise your query named "Total Swaps" or "Total Cases"

If you put something in brackets, the query will look for a field with the name in brackets, if there isn't one available, it will request a value in its place.

If "Total Swaps" and "Total Cases" are expressions built in this query, replace their names with the expression that define each name.

ex., instead of:
Swap %: ([Total Swaps]/[Total Cases])
use
Swap %: sum([Swaps])/sum([Cases])

 

[Infiltrator64]

Thanks for the feed back. What I actually needed to to for this coulmn is set it to Group by Expression to stop the prompt.

 

[dwolf981]

I had same problem....Thanks for posting your solution because I had to change the total from group by to expression as well.