DAVG in query

[amai]

I am trying to do the following expression in a query. Can someone help me to identify the problem and please explain the solution?



DAvg("[Exchange_Rate_Qry]![TO_Exchange_Rate]","[Exchange_Rate_Qry]","[Exchange_Rate_Qry]![TO_Number]='"& [Invoices_View_All]![Contract_Number] & '")

TO_Exchange_Rate is a number field. Everything else are strings.

[Perceptus]

I want to say you should be using like

DAvg("[Exchange_Rate_Qry].[TO_Exchange_Rate]","[Exchange_Rate_Qry]","[Exchange_Rate_Qry].[TO_Number]='"& [Invoices_View_All].[Contract_Number] & '")

[amai]

Awesome! That worked.