Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Location
    dallas
    Posts
    14

    DSUM Problems

    I have a form with fields [amount], [voucher] and a check box [bkd].
    I want to sum the amounts for the vouchers one voucher number may be used several times due to credits. Is this possible?


    PS I need the form in continuous view!!!

  2. #2
    Join Date
    Sep 2006
    Location
    dallas
    Posts
    14
    this is what i have but it sums up all the vouchers not just the ones duplicated please help
    =DSum("[amount]","tbl_Inv_Values","[voucher] = [Voucher]")

  3. #3
    Join Date
    Sep 2006
    Location
    dallas
    Posts
    14
    I figured it out thies what i came up with
    Sum of Voucher Total: DSum("[Amount]","tbl_Inv_Values","[voucher] = '" & [voucher] & "' ")

    I was missing some spaces between quotation marks!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form Combo problems
    By Honeytree in forum Forms
    Replies: 0
    Last Post: 10-05-2008, 01:32 PM
  2. DSUM HELP! I am frustrated
    By PnerraD in forum Reports
    Replies: 2
    Last Post: 09-24-2007, 02:23 PM
  3. Merge Code problems
    By kfergus in forum Access
    Replies: 1
    Last Post: 06-01-2006, 03:36 PM
  4. Problems with run permissions on a query
    By admaldo in forum Queries
    Replies: 0
    Last Post: 05-09-2006, 09:04 AM
  5. Problems with a query in a list box
    By admaldo in forum Forms
    Replies: 1
    Last Post: 04-05-2006, 05:28 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums