Error 3071-Not really sure of cause...

B

Bev

Received the following error:
This expression is typed incorrectly, or it is too complex to be evaluated.
For example, a numeric expression may contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables. (Error 3071)

When Running following SQL Query:

INSERT INTO [2004 Paid] ( Tier, [Pharmacy ID], Claim, Seq, [RX #], [Group
#], DOB, [Member ID], [First Name], [Last Name], [Metric Quantity], [Qty
Disp], [Days Supply], GPI, NDC, [Billed Ingr Cost], [Billed Dispensing],
[Written Date], Prescriber, [PA #], [PA Reason], Status, Company, PCP, [Appr
Ingr Cost], [Disp Fee], [Patient Pay], [GPI List], [GPI Code], [NDC List],
NDC1, NDC2, NDC3, [Fill Date], [GPI Copay Ind Start Date], [GPI Copay Ind End
Date], [GPI Copay Ind Status], [GPI Copay Ind], [NDCCopay Ind Start Date],
[NDC Copay Ind End Date], [NDC Copay Ind Status], [NDC Copay Ind], [Generic
Override], [Plan Drug Status], [Generic ID], [NDC Sch Copay Override], [GPI
Sch Copay Override], [NDC CT Copay Override], [GPI CT Copay Override] )
SELECT [enter Tier 1] AS Tier, [Q000 Claim Selection].[Pharmacy ID], [Q000
Claim Selection].Claim, [Q000 Claim Selection].SEQ, [Q000 Claim
Selection].[RX #], [Q000 Claim Selection].[Group #], [Q000 Claim
Selection].DOB, [Q000 Claim Selection].[Member ID], [Q000 Claim
Selection].[First Name], [Q000 Claim Selection].[Last Name], [Q000 Claim
Selection].[Metric Quantity], [Q000 Claim Selection].[Qty Disp], [Q000 Claim
Selection].[Days Supply], [Q000 Claim Selection].GPI, [Q000 Claim
Selection].NDC, [Q000 Claim Selection].[Billed Ingr Cost], [Q000 Claim
Selection].[Billed Dispensing], [Q000 Claim Selection].[Written Date], [Q000
Claim Selection].Prescriber, [Q000 Claim Selection].[PA #], [Q000 Claim
Selection].[PA Reason], [Q000 Claim Selection].Status, [Q000 Claim
Selection].Company, [Q000 Claim Selection].PCP, [Q000 Claim Selection].[Appr
Ingr Cost], [Q000 Claim Selection].[Disp Fee], [Q000 Claim
Selection].[Patient Pay], [Q000 Claim Selection].[GPI LIST], [Q000 Claim
Selection].[GPI CODE], [Q000 Claim Selection].[NDC List], [Q000 Claim
Selection].NDC1, [Q000 Claim Selection].NDC2, [Q000 Claim Selection].NDC3,
[Q000 Claim Selection].[Fill Date], [Q000 Claim Selection].[RCPGPP Start
Date], [Q000 Claim Selection].[RCPGPP End Date], [Q000 Claim Selection].[GPI
Copay Ind Status], [Q000 Claim Selection].[GPI COPAY IND], [Q000 Claim
Selection].[RCPNPP Start Date], [Q000 Claim Selection].[RCPNPP End Date],
[Q000 Claim Selection].[NDC Copay Ind Status], [Q000 Claim Selection].[NDC
COPAY IND], [Q000 Claim Selection].[Generic Override], [Q000 Claim
Selection].[Plan Drug Status], [Q000 Claim Selection].[Generic ID], [Q000
Claim Selection].[NDC Sch Copay Override], [Q000 Claim Selection].[GPI Sch
Copay Override], [Q000 Claim Selection].[NDC CT Copay Override], [Q000 Claim
Selection].[GPI CT Copay Override]
FROM [Q000 Claim Selection]
GROUP BY [enter Tier 1], [Q000 Claim Selection].[Pharmacy ID], [Q000 Claim
Selection].Claim, [Q000 Claim Selection].SEQ, [Q000 Claim Selection].[RX #],
[Q000 Claim Selection].[Group #], [Q000 Claim Selection].DOB, [Q000 Claim
Selection].[Member ID], [Q000 Claim Selection].[First Name], [Q000 Claim
Selection].[Last Name], [Q000 Claim Selection].[Metric Quantity], [Q000 Claim
Selection].[Qty Disp], [Q000 Claim Selection].[Days Supply], [Q000 Claim
Selection].GPI, [Q000 Claim Selection].NDC, [Q000 Claim Selection].[Billed
Ingr Cost], [Q000 Claim Selection].[Billed Dispensing], [Q000 Claim
Selection].[Written Date], [Q000 Claim Selection].Prescriber, [Q000 Claim
Selection].[PA #], [Q000 Claim Selection].[PA Reason], [Q000 Claim
Selection].Status, [Q000 Claim Selection].Company, [Q000 Claim
Selection].PCP, [Q000 Claim Selection].[Appr Ingr Cost], [Q000 Claim
Selection].[Disp Fee], [Q000 Claim Selection].[Patient Pay], [Q000 Claim
Selection].[GPI LIST], [Q000 Claim Selection].[GPI CODE], [Q000 Claim
Selection].[NDC List], [Q000 Claim Selection].NDC1, [Q000 Claim
Selection].NDC2, [Q000 Claim Selection].NDC3, [Q000 Claim Selection].[Fill
Date], [Q000 Claim Selection].[RCPGPP Start Date], [Q000 Claim
Selection].[RCPGPP End Date], [Q000 Claim Selection].[GPI Copay Ind Status],
[Q000 Claim Selection].[GPI COPAY IND], [Q000 Claim Selection].[RCPNPP Start
Date], [Q000 Claim Selection].[RCPNPP End Date], [Q000 Claim Selection].[NDC
Copay Ind Status], [Q000 Claim Selection].[NDC COPAY IND], [Q000 Claim
Selection].[Generic Override], [Q000 Claim Selection].[Plan Drug Status],
[Q000 Claim Selection].[Generic ID], [Q000 Claim Selection].[NDC Sch Copay
Override], [Q000 Claim Selection].[GPI Sch Copay Override], [Q000 Claim
Selection].[NDC CT Copay Override], [Q000 Claim Selection].[GPI CT Copay
Override]
HAVING ((([Q000 Claim Selection].[Fill Date])>=[RCPGPP Start Date]) AND
(([Q000 Claim Selection].[GPI Copay Ind Status])="A") AND (([Q000 Claim
Selection].[GPI COPAY IND])="G")) OR ((([Q000 Claim Selection].[Fill
Date])>=[RCPGPP Start Date] And ([Q000 Claim Selection].[Fill Date])<=[RCPNPP
End Date]) AND (([Q000 Claim Selection].[GPI Copay Ind Status])="I") AND
(([Q000 Claim Selection].[GPI COPAY IND])="G")) OR ((([Q000 Claim
Selection].[Fill Date])>=[RCPNPP Start Date]) AND (([Q000 Claim
Selection].[NDC Copay Ind Status])="A") AND (([Q000 Claim Selection].[NDC
COPAY IND])="G")) OR ((([Q000 Claim Selection].[Fill Date])>=[RCPNPP Start
Date] And ([Q000 Claim Selection].[Fill Date])<=[RCPNPP End Date]) AND
(([Q000 Claim Selection].[NDC Copay Ind Status])="I") AND (([Q000 Claim
Selection].[NDC COPAY IND])="G")) OR ((([Q000 Claim Selection].[Generic
Override])="Y" Or ([Q000 Claim Selection].[Generic Override])="X") AND
(([Q000 Claim Selection].[Plan Drug Status])="F" Or ([Q000 Claim
Selection].[Plan Drug Status])="H" Or ([Q000 Claim Selection].[Plan Drug
Status])="Z" Or ([Q000 Claim Selection].[Plan Drug Status])="K" Or ([Q000
Claim Selection].[Plan Drug Status])="S" Or ([Q000 Claim Selection].[Plan
Drug Status])="U" Or ([Q000 Claim Selection].[Plan Drug Status])="5" Or
([Q000 Claim Selection].[Plan Drug Status])="6")) OR ((([Q000 Claim
Selection].[Generic Override])="!") AND (([Q000 Claim Selection].[Plan Drug
Status])="F" Or ([Q000 Claim Selection].[Plan Drug Status])="H" Or ([Q000
Claim Selection].[Plan Drug Status])="Z" Or ([Q000 Claim Selection].[Plan
Drug Status])="K" Or ([Q000 Claim Selection].[Plan Drug Status])="S" Or
([Q000 Claim Selection].[Plan Drug Status])="U" Or ([Q000 Claim
Selection].[Plan Drug Status])="5" Or ([Q000 Claim Selection].[Plan Drug
Status])="6") AND (([Q000 Claim Selection].[Generic ID])="Y" Or ([Q000 Claim
Selection].[Generic ID])="X"));

The error occures when the following criteria is added in the [Fill Date]
field of the following poriton of the SQL:

HAVING ((([Q000 Claim Selection].[Fill Date])>=[RCPGPP Start Date]) AND
(([Q000 Claim Selection].[GPI Copay Ind Status])="A") AND (([Q000 Claim
Selection].[GPI COPAY IND])="G")) OR ((([Q000 Claim Selection].[Fill
Date])>=[RCPGPP Start Date] And ([Q000 Claim Selection].[Fill Date])<=[RCPNPP
End Date]) AND (([Q000 Claim Selection].[GPI Copay Ind Status])="I") AND
(([Q000 Claim Selection].[GPI COPAY IND])="G")) OR ((([Q000 Claim
Selection].[Fill Date])>=[RCPNPP Start Date]) AND (([Q000 Claim
Selection].[NDC Copay Ind Status])="A") AND (([Q000 Claim Selection].[NDC
COPAY IND])="G")) OR ((([Q000 Claim Selection].[Fill Date])>=[RCPNPP Start
Date] And ([Q000 Claim Selection].[Fill Date])<=[RCPNPP End Date]) AND
(([Q000 Claim Selection].[NDC Copay Ind Status])="I") AND (([Q000 Claim
Selection].[NDC COPAY IND])="G"))

Any suggestions on how to get around this criteria would be appreciated.
 

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

Similar Threads

NOT ENOUGH SPACE ON TEMPORARY DISK 0
Not enough space on temporary disk 0
Problem in automating using a button created by recording a macro 0
NNTP SPAM 0
EARN FROM HOME 0
WIN MILLIONS SITTING AT HOME 0

Top