Results 1 to 2 of 2
  1. #1
    ajojeda is offline Novice
    Windows 8 Access 2013
    Join Date
    Jul 2014

    Attempting to have single query result display in Text box on Form

    I have the need to display the return of my "Sum Query" to display in a text box.

    I need the attached below value (40500) in the "SumofQuery" attachment, which updates every 5 minutes to display on the "StatusBoard" attachment text box.

    I have been searching for a good 10 hours on how to do this and still cannot find it.

    I know I am over thinking the solution and cannot figure it out.

    Click image for larger version. 

Name:	SumofQuery.PNG 
Views:	8 
Size:	5.5 KB 
ID:	17124Click image for larger version. 

Name:	StatusBoard.PNG 
Views:	8 
Size:	7.2 KB 
ID:	17123

    Any help is greatly appreciated.

    Thanks in advance.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Nevada, USA
    You could use a DLookup() function.
    Paul (wino moderator)
    MS Access MVP 2007-2019

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

Similar Threads

  1. Display Query Form as a Result
    By rescobar in forum Forms
    Replies: 2
    Last Post: 08-19-2013, 11:31 AM
  2. Replies: 1
    Last Post: 01-06-2013, 01:47 PM
  3. Replies: 12
    Last Post: 06-25-2012, 01:42 PM
  4. HELP! Display a query result into form
    By leanne in forum Forms
    Replies: 15
    Last Post: 06-23-2010, 09:18 PM
  5. Query to display in single row
    By access in forum Queries
    Replies: 10
    Last Post: 01-14-2010, 11:40 AM

Tags for this Thread

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