How to get rid of records showing up in the wrong field 1

[Madmaxrtw]

I have the following query:

SELECT [Budget as of 4-1-08].[WBS Element], [Budget as of 4-1-08].Description, [Budget as of 4-1-08].Fund, [Budget as of 4-1-08].[Commitment Item], qryIIFforCurrentPlan.CurrentPlan, [Budget as of 4-1-08].Commitment, [Budget as of 4-1-08].Obligation, [Budget as of 4-1-08].Cost
FROM [Budget as of 4-1-08] INNER JOIN qryIIFforCurrentPlan ON ([Budget as of 4-1-08].[Commitment Item] = qryIIFforCurrentPlan.[Commitment Item]) AND ([Budget as of 4-1-08].[WBS Element] = qryIIFforCurrentPlan.WBSNumber);

It works but--In the query "qryIIFforCurrentPlan" the field CurrentPlan is only supposed to show up when the Fund field is ESAX22008D but it is showing up in both the Fund results???

I hope this is clear enough it is very hard to explain

Thanks in advance

 

[Golom]

If the problem is in the query "qryIIFforCurrentPlan" then perhaps that is what you should be posting.

Further, what does "show up" mean exactly?

Does it mean that the field contains a value when it should be NULL? Note that you can't conditionally include or exclude a column on different rows. If "CurrentPlan" is in the SELECT statement then it will "show up" in every row although its value may be blank or NULL.

Are "CurrentPlan" and "Fund" in the same table or different tables?