Is anyone aware of anything that would suddenly cause the column headings of a query to change?
I have not made any changes to the database or query.
'Allegation 1' is appearing as 'Allegation Code 1'. The caption in the database is set as 'Allegation 1'. The heading that is appearing may be from an old version of the table design or query.
Here is the query:
SELECT BA.CaseNumber AS [Case Number], CaseStatus.Description AS [Case Status], tblCaseTypes.CaseType AS [Case Type], BA.Title19 AS [Non-Title XIX], BA.ContactMethod AS [Contact Method], tblSubjectType.Desc AS [Subject Type], QS.ID AS [Subject ID], QS.ProviderType,
BA.EligibilityAgency AS [Eligibility Agency], QS.Lastname AS [Last Name], QS.Firstname AS [First Name], BA.Target, BA.RelatedId AS [AHCCCS ID], ConvDate(QS.DOB) AS [Date of Birth], QS.PID AS SSN, QS.Citizen AS [US Citizen], QS.HomeStreet1, QS.HomeStreet2,
QS.HomeCity, QS.HomeState, QS.HomeZip, QS.MailStreet1, QS.MailStreet2, QS.MailCity, QS.MailState, QS.MailZip, QS.Phone, BA.TaskForceCase AS [Taskforce?], BA.EDIWatch AS [LexisNexis Queried], BA.PITEval AS [PIT Eval], BA.ReferralSource AS Source, ConvDate(BA.ReferralReceived)
AS [Referral Received Date], BA.Investigator AS Investigator, IT.Team, ConvDate(BA.AssignedDate) AS [Assigned Date], BA.ReferredTo AS [Referred To], ConvDate(BA.ReferredDate) AS [Referred To Date], BA.ResultofInvestigation AS Result, ConvDate(BA.InvestigationEndDate)
AS [Investigation End Date], BA.AtRiskAmount, BA.Allegation1 AS [Allegation 1], Allegations_1.AllegationDescription AS [Allegation Description 1], BA.Allegation2 AS [Allegation 2], Allegations_2.AllegationDescription AS [Allegation Description 2], BA.Allegation3
AS [Allegation 3], Allegations_3.AllegationDescription AS [Allegation Description 3], BA.SourceCaseNumber AS [Source Case #], ConvDate(BA.CMPFiledDate) AS [CMP Filed], ConvDate(BA.CMPRcvdDate) AS [CMP Received], ConvDate(BA.CMPPlus30) AS [30 Day Date], ConvDate(BA.CMPPlus60)
AS [60 Day Date], BA.Recoveries, BA.HealthPlanSavings AS [HP Recoveries/Sanctions], BA.ProgramSavings AS [Program Savings], BA.InvestigativeCosts AS [Investigative Costs Recovered], BA.ProsecutionCaseNumber AS [Prosecution Case #], BA.ProsecutionStatus AS
[Prosecution Status], BA.PaymentsSuspended AS [Payments Suspended?], ConvDate(BA.SentenceDate) AS [Sentence Date], BA.SentenceTimeYears AS [Confinement Years], BA.SentenceTimeMonths AS [Confinement Months], BA.ProbationTimeYears AS [Probation Years], BA.ProbationTimeMonths
AS [Probation Months], BA.CommunityServiceTimeHours AS [Community Service Hours], BA.AssetForfeiture AS [Asset Forfeiture], tblAR.DueAmt AS [Recoveries/Fine], qryAR.TotPaid AS [Amount Paid To Date], qryAR.BalDue AS [Balance Due], ConvDate(qryAR.LastPay) AS
[Last Payment Date], tblAR.PayorName AS [Payor Name], tblAR.PayorStreet1 AS [Payor Street 1], tblAR.PayorStreet2 AS [Payor Street 2], tblAR.PayorCity AS [Payor City], tblAR.PayorState AS [Payor State], tblAR.PayorZip AS [Payor Zip], tblAR.PayAmt AS [Settlement
Terms Payment Amount], ConvDate(tblAR.InitialPayDate) AS [Initlal Payment Date], tblPaymentInterval.Interval AS [Payment Interval], tblAR.NumPayments AS [Number Of Payments], BA.Comments, BA.Comments2, tblAR.CollectDate, tblAR.Notes, BA.LastUpdBy AS [CaseData_Last
Updated By], ConvDT(BA.LastUpdDt) AS [CaseData_Last Updated], QS.LastUpdBy AS [Subject_Last Updated By], ConvDT(QS.LastUpdDt) AS [Subject_Last Updated], tblAR.LastUpdBy AS [AR_Last Updated By], ConvDT(tblAR.LastUpdDt) AS [AR_Last Updated]
FROM (CaseStatus RIGHT JOIN (tblSubjectType RIGHT JOIN (qryInvestigatorTeams AS IT RIGHT JOIN (Allegations AS Allegations_2 RIGHT JOIN (Allegations AS Allegations_3 RIGHT JOIN (Allegations AS Allegations_1 RIGHT JOIN (tblPaymentInterval RIGHT JOIN (tblCaseTypes
INNER JOIN (qrySubjects AS QS RIGHT JOIN (tblAR RIGHT JOIN [Beth Afirms] AS BA ON tblAR.CaseNumber = BA.CaseNumber) ON QS.ID = BA.SubjectId) ON tblCaseTypes.ID = BA.CaseTypeId) ON tblPaymentInterval.ID = tblAR.PayInterval) ON Allegations_1.AllegationCode =
BA.Allegation1) ON Allegations_3.AllegationCode = BA.Allegation3) ON Allegations_2.AllegationCode = BA.Allegation2) ON IT.Investigator = BA.Investigator) ON tblSubjectType.ID = QS.Type) ON CaseStatus.CaseStatusCode = BA.CaseStatus) LEFT JOIN qryAR ON BA.CaseNumber
= qryAR.CaseNumber
WHERE BA.CaseNumber>=[From Case #] And BA.CaseNumber<=[To Case #];
