hi everyone, ok i have created a solution that keeps track of our sales reps daily amounts. it will be a summary of the week. on monday afternoon i want it to start over, a count of 0. i also would like to paste the the final total into a field. the big question is can i automate it?

Peter.

i have taken a course in cdml and i just realized how easy it is!!!

You can have a calculated field which tells you the week & year. You can then do a search on that week and have a Summary field tell you the amount for each sales person.

You can automate by scripting the search and report.

All the best.

Garry

Here is the calculation for determining the week from a date:

NumToText(WeekofYear(sales_date)) & NumToText(Year(sales_date))

Hope this helps.

Garry