[mihaufo]

I have a table containing dates, product type, no. of units sold.

The date field contains duplicate dates.
ex:
DATE | PRODUCT | UNITS SOLD
1-JUN | A | 10
1-JUN | B | 23
2-JUN | A | 20
3-JUN | A | 30
4-JUN | A | 10
4-JUN | B | 30

Now, I would like to get the average of UNITS SOLD, based on number of unique dates.
How to calculate/count number of unique dates from the date field.
In the above example the number of unique dates should be 4 and average should be (123/4) = 30.75

Thanks

[GeorgeJ]

Does this do it?

=SUM(C1:C7)/SUM(IF(FREQUENCY(A1:A7,A1:A7)>0,1))

[mihaufo]

Yes, this works in Excel, but I would like to do it in Access.

[GeorgeJ]

Might be worth editting your first post and putting Access Query: in the title. I'm afraid i'm useless with Access. Sorry.