outer joins all of sudden not working.

  • Thread starter Thread starter grace
  • Start date Start date
G

grace

I am hoping someone can help me with a query problem. I
created a query that has outerjoins on four fields between
two tables. See below:

tblBudget tblActuals

[JobCode] [JobCode]
[FTPTStatus [FTPTSTatus]
[OfficeNumber] [OfficeNumber]
[DeptNumber] [DeptNumber]

I want ALL fields from the tblBudget table to display and
only those fields from the tblActuals that match. My
query WAS WORKING before and is not anymore. What happens
is if there is not match in the tblActuals, the value from
the budget table doesn't display. I can not figure out why
it is not working anymore as I have made VERY few changes
to the tblBudget table. I hope this post is not too vague
for a response.

Let me know if you have questions.

Thanks, Grace
 
I want ALL fields from the tblBudget table to display and
only those fields from the tblActuals that match. My
query WAS WORKING before and is not anymore.
Click to expand...

The most likely cause is that you have added a criterion on some field
in tblActuals. ANY criterion will require that the record in
tblActuals must exist (otherwise it won't match that criterion),
unless you change the criterion to

<somevalue> OR IS NULL

where the NULL option will pick up those records in tblBudget which
have no match in tblActuals.
 
Back
Top