Results 1 to 6 of 6
  1. #1
    keiath is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    162

    Qyery result to display on form

    I have query, which is working fine and returns the results needed

    on my form i want to display that result

    =DSum([Billing]![Site Number],[Billing]![SumOfTotal])

    This is what I am doing, but it doesnt work comes up with the error message #Name?



    ANyone got any ideas as to what I am doing wrong?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    From the help file
    DSum(Expr, Domain, Criteria)

    What is it you are trying to add? Is the value already in the query? What is the name of the query?

    Expr = A field name. It looks like you are trying to use the name of a control
    Criteria = Matching something (usualy a variable) to a value in a field

  3. #3
    keiath is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    162
    the Name of the query is Billing

    Query is returning the correct answer, all i want to do is display the result for that record on the form

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe you can join your totals query to the query or table your form is bound to.

    Another opttion would be something like Dmax. You can add criteria if you want and you don't really need the max value but..

    = Dmax("[SumOfTotal]","[Billing]")

  5. #5
    keiath is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    162
    That Worked perfectly, thank you

  6. #6
    keiath is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    162
    That Worked perfectly, thank you

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

Similar Threads

  1. Replies: 3
    Last Post: 09-12-2013, 02:18 PM
  2. Display Query Form as a Result
    By rescobar in forum Forms
    Replies: 2
    Last Post: 08-19-2013, 11:31 AM
  3. Replies: 1
    Last Post: 06-09-2012, 05:44 PM
  4. Replies: 7
    Last Post: 05-31-2012, 02:25 PM
  5. HELP! Display a query result into form
    By leanne in forum Forms
    Replies: 15
    Last Post: 06-23-2010, 09:18 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