Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: sum() gives error

    hi all,

    i recently undertook a new project and got stuck at this problem when i was about to complete the project. this project was actually a half created database, which i'm supposed to improve and complete it.

    I got this form displaying the different kinds of spare parts with the amount of usage per month and the cost per unit, in continuous form mode. by the way, this form's record source is from a crosstab query.

    so, i created these text boxes to display the total amount of money spent for every month, for all types of parts. this is wat i used:

    for the old version, this formula gives the correct output. but for my version it does not gives any output except #Error.

    note that the old and new file is in Access 2000. any idea why this is happening, anyone?

  2. #2
    Join Date
    Feb 2004
    Dorset UK

    Maybe its trying to use a text value to multiply ?

    Jan (the field) in the table or its origin is it a number or text ?



Posting Permissions

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