Davg not working in query

[mike9629]

Hi,

I am trying to get the average of a select group of records within a query. It appears the davg function should give me what I need, however my query returns no results. Here is a sample of my data.

Item Cost Basis Group Cost
1HF20812 1HF208 6.17
1HF20816 1HF208 8.63
1HF20820 1HF208 9.44

Here is the davg string I am trying to use.

Group: davg("Cost","Cost Basis Group")

I appreciate any help I can get. Thanks !!!

 

[WayneRyan]

Mike,

Group: davg("[Cost]", "YourQueryName", "[Cost Basis Group] = '1HF208'")

Wayne

 

[mike9629]

Wayne,

I appreciate your response. I am now receiving values. Is there a way to average values for multiple groups of values within the same table? For example I need the average cost for 5 items with a cost group = 1HF208 and 5 items with a cost group of = 1HF210?

Thanks for your help.

Mike