I have an access database that calculates a score for each salesman. All the forumlas I am currently using are below. I need a formula that uses the "open" [status] and gives it a -1 if the open date is 30 greater than today's date. (using valid fr date). Below is all the formulas I currently have. At the end I will add all the points for every salemen to get a total number. Let me know if you need more info.
Ordered Points: IIf([status]="Ordered",5,0)
Closed Points: IIf([status]="Closed",1,0)
Open Points: (formula inquiring about)
Rejection Reason Points: IIf([Rejection Reason]=" ",0,1)
Competitor Lost Points: IIf([MFG]=" ",0,1)
Distributor Lost Points: IIf([DIST]=" ",0,1)
Attachment 229983
Bookmarks