AnsweredAssumed Answered

A field calc for......

Question asked by margedant on Nov 1, 2010
Latest reply on Nov 1, 2010 by philmodjunk


A field calc for......


A field calc for for a list of sales with different dates which totals the sales of matching dates, not the whole list.

1 table, no relationships

Using fields:

Sales date

Sales Amount

(Calc field) Total sales by date

THE KEY IS TO: sum(Sales Amount) for all the same dates!!

Thanks for any help