+ Reply to Thread
Results 1 to 1 of 1

i wanted to display usernames and number records or data is allocated to them it is

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    i wanted to display usernames and number records or data is allocated to them it is

    I wanted to Display in EXCEL Sheet It is possible

    I have database name called projects

    table name -->tblprod_agr_002,tblprod_agr_001.....etc

    in that table i have unique column name called FQR_User_Code

    FQR_User_Code
    sunil
    sunil
    sunil
    sunil
    ramesh
    ramesh
    ....etc

    I wanted to Display in EXCEL Sheet It is possible

    like THIS

    FQR USER NAME TOTAL_RECORDS_ALLOATED
    SUNIL 4
    RAMESH 2


    Please help me how can i do this

    gave me some examples

    i have attached my file i am trying do it in macros
    Attached Files Attached Files
    Last edited by baig123; 08-12-2014 at 01:52 AM. Reason: paragraph

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Userform spin button different way to display number of records
    By guitarsweety in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2014, 08:09 AM
  2. [SOLVED] Display with first three text name with highest number of records based on date
    By abraham30 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2014, 07:01 PM
  3. Display number of records found in a mesage box
    By richiev4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2012, 06:42 PM
  4. Replies: 3
    Last Post: 01-06-2012, 11:16 PM
  5. Formula to see if a number is allocated
    By Ernest Lai in forum Excel General
    Replies: 2
    Last Post: 11-25-2005, 10:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1