Unresolved problem

chivo123

Registered User.
Local time
Today, 06:31
Joined
Jan 20, 2012
Messages
21
Hey all,
I have posted a problem 6 days and I still haven't got any answer back.
Open up the database faculty ---> click on faculty Details --> then page 294.

On that form --> what I want to do when I choose agent name on the top, and select the dates, it will populate me with the average of the span date.

For instance, when I click on Test, and I want it to get the AVG of date from Dec 20th-- Dec 23rd. somehow when I put this formula (=IIf(Int(DateDiff("d",[Date],[End Date]))>1,Sum([Average Wrap]),"Siavash"), all functions work, but it doesn't return me the sum average Wrap.

When I put this formula and I select difference date of more than 2, it returns me the value of multipication.
=IIf(Int(DateDiff("d",[Date],[End Date]))>1,5*10,"Siavash")

any solutions please????
 

Attachments

Users who are viewing this thread

Back
Top Bottom