Results 1 to 2 of 2
  1. #1
    cowboy is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    291

    how to get total query into textbox in form???

    I have a database with a bunch of records, now I want to summarize this info. I made a query that is written like;

    SELECT Inspections.Area, Count(Inspections.Area) AS NumMH


    FROM Inspections
    GROUP BY Inspections.Area;

    and produces something like ;

    Area NumMH
    0
    APCB 16
    APD3 10
    APDG 6

    I want to get that information into text boxes in a form but I dont know how to extract the information because each row isnt a record and I would like to be able to use the Area to associate with the NumMH Any help would be appreciated, thanks.

  2. #2
    NassauBob's Avatar
    NassauBob is offline Not THAT Green
    Windows XP Access 2003
    Join Date
    Feb 2010
    Location
    Augusta, GA
    Posts
    61
    Hi. Can you not set a datasheet view of the query results on to the form, as an object?

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

Similar Threads

  1. multiple textbox in a form
    By iamraja5 in forum Programming
    Replies: 2
    Last Post: 01-26-2010, 10:53 AM
  2. Total a Query
    By Bridgid in forum Queries
    Replies: 0
    Last Post: 09-05-2009, 02:51 PM
  3. Replies: 3
    Last Post: 03-28-2009, 06:06 PM
  4. total in textbox
    By micfly in forum Access
    Replies: 3
    Last Post: 11-09-2008, 11:24 AM
  5. Replies: 1
    Last Post: 08-10-2008, 01:09 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