S

#### Stacey Crowhurst

Q- Cash Flow_Uncommitted Costs 01

Q- Cash Flow_Uncommitted Costs 02

Q- Cash Flow_Uncommitted Costs 03

Q- Cash Flow_Uncommitted Costs 04

Q- Cash Flow_Uncommitted Costs 05

I updated queries 02 and 04 by pulling an additional field (yes/no box) from

my tables. They both run fine on their own and display the additional field.

However in query 05, when I try to pull in the new field [Use Uncommitted

Budget] I get the "No Current Record" error. *Note, I did not change

anything to query 01*

Here is the SQL:

SELECT [Q- Cash Flow_Uncommitted Costs 01].[CCP No], [Q- Cash

Flow_Uncommitted Costs 01].Type, [Q- Cash Flow_Uncommitted Costs 01].[Budget

Code], [Q- Cash Flow_Uncommitted Costs 01].[Budget Code Desc], [Q- Cash

Flow_Uncommitted Costs 01].[Uncommitted Budget], IIf(IsNull([Q- Cash

Flow_Uncommitted Costs 02]!PCOs),0,[Q- Cash Flow_Uncommitted Costs 02]!PCOs)

AS PCOs, [Q- Cash Flow_Uncommitted Costs 04].[Use Uncommitted Budget] AS [PCO

Box], IIf(IsNull([Q- Cash Flow_Uncommitted Costs 04]![PM Projections]),0,[Q-

Cash Flow_Uncommitted Costs 04]![PM Projections]) AS [PM Projections], [Q-

Cash Flow_Uncommitted Costs 02].[Use Uncommitted Budget] AS [PM Box]

FROM ([Q- Cash Flow_Uncommitted Costs 01] LEFT JOIN [Q- Cash

Flow_Uncommitted Costs 04] ON ([Q- Cash Flow_Uncommitted Costs 01].[Budget

Code] = [Q- Cash Flow_Uncommitted Costs 04].[Budget Code]) AND ([Q- Cash

Flow_Uncommitted Costs 01].[CCP No] = [Q- Cash Flow_Uncommitted Costs

04].[CCP No])) LEFT JOIN [Q- Cash Flow_Uncommitted Costs 02] ON ([Q- Cash

Flow_Uncommitted Costs 01].[Budget Code] = [Q- Cash Flow_Uncommitted Costs

02].[Budget Code]) AND ([Q- Cash Flow_Uncommitted Costs 01].[CCP No] = [Q-

Cash Flow_Uncommitted Costs 02].[CCP No])

GROUP BY [Q- Cash Flow_Uncommitted Costs 01].[CCP No], [Q- Cash

Flow_Uncommitted Costs 01].Type, [Q- Cash Flow_Uncommitted Costs 01].[Budget

Code], [Q- Cash Flow_Uncommitted Costs 01].[Budget Code Desc], [Q- Cash

Flow_Uncommitted Costs 01].[Uncommitted Budget], IIf(IsNull([Q- Cash

Flow_Uncommitted Costs 02]!PCOs),0,[Q- Cash Flow_Uncommitted Costs 02]!PCOs),

[Q- Cash Flow_Uncommitted Costs 04].[Use Uncommitted Budget], IIf(IsNull([Q-

Cash Flow_Uncommitted Costs 04]![PM Projections]),0,[Q- Cash Flow_Uncommitted

Costs 04]![PM Projections]), [Q- Cash Flow_Uncommitted Costs 02].[Use

Uncommitted Budget];

What happened to make this error? I need the box so I can do calculations

based on the yes/no answer. Any help is appreciated. Let me know if you

need more information.