Linking Tables for a Query

[Guest]

I have 2 tables. Job Info and RenoNew

Job Info includes:
Job #
Job Name
RenoNew ID
etc
etc

RenoNew includes:
RenoNew ID
RenoNew Description

I am using a query to give me Job Number (user enters specific job #) and
RenoNew Description. I have the relationship between the 2 tables set to
RenoNew ID. When I use the query to just show Job # and Job Name it works.
When I add the 2nd table to show RenoNew Description, it doesn't show any
records. Any idea to what I am doing wrong?

 

[Guest]

The result you are getting implies that there are no matches betwen the
[RenoNewID] fields in the two tables.

Have you checked to make sure that the values in the RenoNewID field in your
[Job Info] table actually exist in the [RenoNew] table?

Dale

 

[Guest]

That field is actually empty in all records as it is a new field. I was
hoping to use a query as I am adding info to that field for each record that
would show all records for which that field was still empty. Is that
possible?

The result you are getting implies that there are no matches betwen the
[RenoNewID] fields in the two tables.

Have you checked to make sure that the values in the RenoNewID field in your
[Job Info] table actually exist in the [RenoNew] table?

Dale

I have 2 tables. Job Info and RenoNew

Job Info includes:
Job #
Job Name
RenoNew ID
etc
etc

RenoNew includes:
RenoNew ID
RenoNew Description

I am using a query to give me Job Number (user enters specific job #) and
RenoNew Description. I have the relationship between the 2 tables set to
RenoNew ID. When I use the query to just show Job # and Job Name it works.
When I add the 2nd table to show RenoNew Description, it doesn't show any
records. Any idea to what I am doing wrong?

 

[John Vinson]

That field is actually empty in all records as it is a new field. I was
hoping to use a query as I am adding info to that field for each record that
would show all records for which that field was still empty. Is that
possible?

A criterion of

IS NULL

will show all the records for which it is null. Obviously, a NULL
value cannot be used to join two tables!

John W. Vinson[MVP]