Results 1 to 11 of 11

Thread: Why does this not work? **Resolved**

Threaded View

  1. May 29th, 2003, 11:09 AM #1
    Matt_T_hat
    Matt_T_hat is offline

    Thread Starter
    Fanatic Member Matt_T_hat's Avatar
    Join Date
    Dec 2001
    Location
    '76 Male Body Evil-Errors: 666
    Posts
    774

    Why does this not work? **Resolved**

    On the footer of a from set to "Continuous Forms" I have a text box with this code in it.

    =IIf(IsNull(Sum([FinalPrice])),0,Sum([FinalPrice]))

    FinalPrice is the name of a text box that contains another calculation. Why should this not work this time?

    Last time I did this the form was backed by a table and was filtered. this time it's backed by a query. surely that's not the reason!?

    the output is: #Error
    Last edited by Matt_T_hat; Jul 31st, 2003 at 06:04 AM.
    ?
    'What's this bit for anyway?
    For Jono
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width