I know one of you out there can help me with this. I posted yesterday, but hoping to find some help pretty fast.
Here's the deal. I have used this expression in another database and it works. But it won't in this one. The only thing I can think of, is the other database was created using Access 97 and I'm now using 2000. Heck, that might not be it, but it satisfies me so far. Anyway, what I'm trying to do is look up in a field and get the total contract price for all records that have no closing date. Maybe my formula will help to understand
=Abs(Sum([Contract Price]*(IsNull([Date Closed]))
Don't ask me how I finally figured it out for the existing database but I did, and it works perfectly.
What am I doing wrong?? I appreciate any help.
Bobbi
Here's the deal. I have used this expression in another database and it works. But it won't in this one. The only thing I can think of, is the other database was created using Access 97 and I'm now using 2000. Heck, that might not be it, but it satisfies me so far. Anyway, what I'm trying to do is look up in a field and get the total contract price for all records that have no closing date. Maybe my formula will help to understand
=Abs(Sum([Contract Price]*(IsNull([Date Closed]))
Don't ask me how I finally figured it out for the existing database but I did, and it works perfectly.
What am I doing wrong?? I appreciate any help.
Bobbi