Results 1 to 2 of 2
  1. #1
    BrockWade is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Dec 2013
    Posts
    63

    how to bind a textbox to summation query's value

    How can I bind a textbox to summation query's value? I tried the formula builder and this did not work: =[qryAutoMatchSum]![SumField]

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Can't reference table or query directly. Table or query must be included in form RecordSource or use a domain aggregate function in textbox expression.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 10-15-2013, 07:50 AM
  2. summation with empty fields
    By danieltaylor in forum Access
    Replies: 3
    Last Post: 11-05-2012, 01:35 AM
  3. Summation of N Number of fields
    By deepanadhi in forum Queries
    Replies: 5
    Last Post: 06-07-2012, 10:48 PM
  4. Conditional Summation
    By megabrown in forum Queries
    Replies: 15
    Last Post: 12-08-2010, 06:19 PM
  5. Incorrect summation in report footer
    By wizard_chef in forum Reports
    Replies: 2
    Last Post: 12-07-2009, 06:53 AM

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