No Current Record Query Error

  • Thread starter Stacey Crowhurst
  • Start date
S

Stacey Crowhurst

Hi. I had a series of queries that worked just fine.

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.
 
J

Jerry Whittle

Here's something from Allen Browne that may explain the problem especially
since you added some Yes/No fields to the mix.

http://allenbrowne.com/bug-14.html
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Stacey Crowhurst said:
Hi. I had a series of queries that worked just fine.

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.
 
S

Stacey Crowhurst

Thank you. That link was very helpful!

Jerry Whittle said:
Here's something from Allen Browne that may explain the problem especially
since you added some Yes/No fields to the mix.

http://allenbrowne.com/bug-14.html
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Stacey Crowhurst said:
Hi. I had a series of queries that worked just fine.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top