Results 1 to 2 of 2
  1. #1
    YaseenIskaf is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    14

    hello Everyone who can give help on this ?

    please open the link

    https://www.accessforums.net/queries/total-record-each-query-show-main-dashboard-35085.html


  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Paul gave you an answer.

    Another method:
    You would need to use VBA to:
    1) open the query
    2) get the record count
    3) Push the value into the text box control
    4) close the query
    5) Repeat as necessary (4 more times)

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

Similar Threads

  1. how to give a code for save and refresh
    By venu_resoju in forum Forms
    Replies: 7
    Last Post: 04-03-2013, 12:29 PM
  2. Query to give Subtotals of field
    By dinesh_ltjd in forum Access
    Replies: 2
    Last Post: 01-12-2013, 01:18 PM
  3. DB will not give Unique ID's
    By DICKBUTTONS in forum Access
    Replies: 1
    Last Post: 02-07-2012, 02:12 PM
  4. Should I give Up on This Form?
    By Palomino33 in forum Forms
    Replies: 25
    Last Post: 11-09-2011, 05:37 AM
  5. Replies: 3
    Last Post: 10-13-2011, 08:40 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