My query contains the following two fields (among others):
Query Field #1
Credits (numeric data type)
("Total" in Design View is set to "Sum"; an aggregate function)
Query Field #2
FTE: [SumOfCredits]/15
When I run this query, I'm prompted to enter a parameter value for "SumOfCredits." If I just click "OK" without entering any value and allow the query to run, it appears to run correctly--the query results are correct.
Why is it prompting me for a parameter value? Is there any possibility of incorrect or unexpected query results in this situation, and, if so, is there a work-around?
Thank you!