Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2009
    Location
    INDIA
    Posts
    35
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hello,

    I am creating a Database using MS Access 2003 and am facing problem while running a query.

    Basically, I have a set of 1825 documents, out of which 631 holds some link related errors. All of these documents are worked on by different writers and have a unique identifier. I want to create a query Table that lists the unique identifiers of error affected documents along with their respective writers name.

    I have two separate tables created in Access, one (complete_report) containing the information of all 1825 documents and another table (for_processing) comprising the unique identifier of only affected documents (631).

    I want to run a query that fetches the unique identifier from for_processing table and writers name from complete_report table. However when I run the query, I get the resultant query table listing only 36 entries, whereas the unique identifiers and the writer name of the remaining 595 documents is very much present in the complete_report table. I am unable to understand why its only picking up 36 entries ignoring the remaining 595 documents.


    Thanks,
    gurpreet

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I assume that the 2 are being linked in the query.
    Normally you would only get rows where there is an Identical match on the linking field(s).
    You need to look at this to try and see why you only get 36 rows.
    How many rows where you hoping to get?
    Andrew

  3. #3
    Lounger
    Join Date
    Jun 2010
    Location
    Manchester, NH
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Assuming the following table structures

    Complete_Report
    ID (Long Integer)
    WriterName (Text)

    For_Processing
    ID (Long Integer)

    The Query Should read:

    SELECT For_Processing.ID, Complete_Report.WriterName
    FROM Complete_Report INNER JOIN For_Processing ON Complete_Report.ID = For_Processing.ID

    Pay particular attention to the Data Types in the tables as the data types on the Join Fields need to be the same.

    Bob Oxford
    Bob Oxford
    Software Wizards, Inc.

  4. #4
    Lounger
    Join Date
    Mar 2009
    Location
    INDIA
    Posts
    35
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thank you ALL for the support !!

    I found that the report, I was using to create the Database was corrupt, which is why it was not allowing the query to run successfully

    Thanks again and have a Nice day !!


    regards,
    gurpreet



    Quote Originally Posted by Bob Oxford View Post
    Assuming the following table structures

    Complete_Report
    ID (Long Integer)
    WriterName (Text)

    For_Processing
    ID (Long Integer)

    The Query Should read:

    SELECT For_Processing.ID, Complete_Report.WriterName
    FROM Complete_Report INNER JOIN For_Processing ON Complete_Report.ID = For_Processing.ID

    Pay particular attention to the Data Types in the tables as the data types on the Join Fields need to be the same.

    Bob Oxford

Posting Permissions

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