Adding existing field to query returns blank

[kaitlinquinn]

I'm working with a query that was created by someone before me. It's a simple query that displays information that has been put into one database, but not another. All I'm trying to do is add an existing data field so that it displays when I run the query. However, when I added the field, everything in the new column returned blank. I looked into the table this field is pulling from and there is information in it, so I don't know why it's not displaying. I've tried all the fixes I can think of to no avail. Any help would be greatly appreciated!

[rpeare]

If the two tables are the same are you sure you're pulling the field from the correct table? Depending on the nature of your join there may not be data in the field for the specific items showing in the query, have you verified that some of your data actually has a value in that field that should appear?

[casinc815]

please provide the SQL statement for review? Thanks!

[kaitlinquinn]

SELECT dbo_legheader.mov_number, dbo_legheader.lgh_refnum, dbo_legheader.lgh_tractor, dbo_legheader.lgh_carrier, dbo_legheader.lgh_startdate, tblCCLoads.LoadNo, dbo_legheader.lgh_startstate, dbo_legheader.lgh_endstate
FROM dbo_legheader LEFT JOIN tblCCLoads ON dbo_legheader.lgh_refnum = tblCCLoads.LoadNo
WHERE (((dbo_legheader.lgh_refnum) Is Not Null And (dbo_legheader.lgh_refnum)<>"0") AND ((dbo_legheader.lgh_carrier)<>"unknown" And (dbo_legheader.lgh_carrier) Not Like "XDCK*") AND ((dbo_legheader.lgh_startdate) Between #1/1/2013# And [start date]) AND ((tblCCLoads.LoadNo) Is Null))
ORDER BY dbo_legheader.lgh_startdate, tblCCLoads.LoadNo;

[rpeare]

which field from which table did you add to this query?

[casinc815]

which field from which table did you add to this query?

dbo_legheader.lgh_refnum = tblCCLoads.LoadNo

The above line indicates a join but how do you join a null value?

Further down in the WHERE clause you are allowing for a null on tblCCloads.LoadNo!
If this is true then your blank may be do to a null value somewhere in the data.

Also, this field is in the OrderBY but it can be a null value.

jim