Results 1 to 3 of 3

Thread: DSUM Problem

  1. #1
    Join Date
    Feb 2005
    Posts
    46

    Unanswered: DSUM Problem

    this is an example of what i'm trying to do:

    dim x as interger
    dim itemTotal as double
    x = 23
    itemTotal = DSum("[item_price]", "table_item", "[item_job_ref] = x")

    Error 2001
    you cancelled the previous operation

    yet if I replace x with 23 it does the sum,
    anyone got any ideas?

    many thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    blah blah... [item_job_ref] = " & x)

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Feb 2005
    Posts
    46
    cheers chap that did it

Posting Permissions

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