Trouble with running a query

Topic

New Reply

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

Reply | Quote

Replies

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?

Reply | Quote

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

Reply | Quote

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

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

Reply | Quote