I have a string in my form like this.
Me.Asking_Rent_Average = (Nz(Me.Asking_Rent_LOW, 0) + Nz(Me.Asking_Rent_HIGH, 0)) / 2
This basically adds two fields and puts the average in the form field.
Now I need to create a query that will add the table column data and give me an average without adding the zeros. I had to put a default zero in the cell. Right no my "test" SQL looks like this.
SELECT DISTINCTROW TradeArea.TradeAreaID, Count(*) AS [Count Of Property], Avg(Property.AskingRentAVERAGE) AS AvgOfAskingRentAVERAGE
GROUP BY TradeArea.TradeAreaID