counting uniquevalues in a field

[aimorris]

I am trying to find the average value of a group heading in a report over a period of days. The problem is that there are multiple entries for each day and The avg()function is counting each entry. I want to count each day only once. Is there a way I can count repeating values only once? Thanks in advance.

 

[SteveM]

The only way I can think of achieving this is to do the calculation in an underlying query.

 

[David R]

You can do it with a Totals query that you then Avg, but how do you determine which record to use for the summation? Or are they always all the same for the same day (in which case, why are they stored more than once?).