Recent content by 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

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...