Parameter Query?

[luckysarea]

Hi, I need some help.



I have generated a query based on another query. Here is the query i have made:


The Query consists of only these four fields. The custom field PER DAY PAYMENT CAPACITY is based on the expression :
Per Day Payment Capacity: [AvgOfFine Silver Charged And Fully Paid For]/[AvgOfFull Payment Period]

Now when i run this query, it acts as a parameter query. Two msg box appear one after the other asking me to input values for "AvgOfFine Silver Charged And Fully Paid For" and AvgOfFull Payment Period.

I have matched the names of the field with the names in the expression, they both are same. I have even inserted the names through the Expression Builder.

why is this happening?

Thanx in advance!

[pbaldy]

It has to do with the order the clauses are evaluated in. You need to group by the expression rather than the alias:

SELECT...
FROM...
GROUP BY Avg(OriginalFieldName)/Avg(OtherFieldName)

[luckysarea]

It has to do with the order the clauses are evaluated in. You need to group by the expression rather than the alias:

SELECT...
FROM...
GROUP BY Avg(OriginalFieldName)/Avg(OtherFieldName)

Thank you!! My query is working fine now.

[pbaldy]

Happy to help!