Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2013
    Posts
    1

    Unanswered: MS Access Query in SQL

    Hello

    I have 25 tables in ms access database. Each of the table has single column named Email. Each of tables contains some hundreds of email ids in it.

    I want to make a report using these tables in ms access. The Report should look like below.

    Summary Report of email database

    No. of Emails from table1 = Total no. of records in table1
    NO. of Emails from table2= Total No. of records in table2.
    ----
    ----
    and so on
    No. of Emails from table 25 = Total no. of records in table25.

    --------------
    Total no. of Emails in database = sum of records of each table.


    Please help me, how this can be done.
    Thanks
    With Regards
    Manoj

  2. #2
    Join Date
    Jun 2013
    Posts
    1
    SELECT MSysObjects.Name, DCount('*',[Name]) AS TotalCount
    FROM MSysObjects
    WHERE (((MSysObjects.[Type])=6));

    I used Dcount for counting but if you want to add specific column then change it to DSUM

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Two identical Tables in a single Database is inappropriate, why, pray tell, do you have 25?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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