B
BobC
Why would a query field (EXPL_TF_PROP_TOTAL) that prints fine in data
sheet view not be available to a report that has that query as it's only
source? All other fields show up as available to the report. I have
included the query SQL if that will help?
SELECT qryClaimDetails.DACC, qryClaimDetails.DRPT,
qryClaimDetails.[CLAIM#], qryClaimDetails.COV, qryClaimDetails.HANAME,
qryClaimDetails.POLYR, qryClaimDetails.SUBIND, qryClaimDetails.HA,
qryClaimDetails.DESCR, qryClaimDetails.CLAIMANT, qryClaimDetails.STATUS,
qryClaimDetails.CURRES, qryClaimDetails.DCURRES, qryClaimDetails.RESCHG,
qryClaimDetails.SumOfPDLEGAL, qryClaimDetails.SumOfPDLOSS,
qryClaimDetails.SumOfPDOTHEREXP, qryClaimDetails.Incurred,
qryClaimDetails.MEMDED_PROP, qryClaimDetails.MEMDED_TF,
qryClaimDetails.MEMDED_AUTOPHY,
Nz([MEMDED_TF],0)+Nz([MEMDED_AUTOPHY],0)+Nz([MEMDED_PROP],0) AS
MEMDED_PROP_TF_AUTOPHY_TOTAL, qryClaimDetails.MHAPDED_PROP,
qryClaimDetails.MHAPDED_TF, Nz([MHAPDED_TF],0)+Nz([MHAPDED_PROP],0) AS
MHAPDED_PROP_TF_TOTAL, qryClaimDetails.PLSA_PROP,
qryClaimDetails.PLSA_TF, Nz([PLSA_TF],0)+Nz([PLSA_PROP],0) AS
PLSA_PROP_TF_TOTAL, qryClaimDetails.EXPL_PROP, qryClaimDetails.EXPL_TF,
Nz([EXPL_TF],0)+Nz([EXPL_PROP],0) AS EXPL_TF_PROP_TOTAL,
qryClaimDetails.EXLL_GL, qryClaimDetails.EXLL_EPL,
Nz([EXLL_GL],0)+Nz([EXLL_EPL],0) AS EXLL_GL_EPL_TOTAL,
qryClaimDetails.AutoPhyGndUp, qryClaimDetails.PropGndUp,
qryClaimDetails.OtherGndUp, [PropGNDUp]+[AutoPhyGndUp]+[OtherGndUp] AS GNDUP
FROM qryClaimDetails
WHERE (((qryClaimDetails.DACC) Between
DateSerial([Forms]![frmClaimDetail]![cboBeginYear],[Forms]![frmClaimDetail]![cboBeginmonth],1)
And
DateSerial([Forms]![frmClaimDetail]![cboEndYear],[Forms]![frmClaimDetail]![cboEndmonth]+1,0)))
ORDER BY qryClaimDetails.DACC, qryClaimDetails.[CLAIM#];
sheet view not be available to a report that has that query as it's only
source? All other fields show up as available to the report. I have
included the query SQL if that will help?
SELECT qryClaimDetails.DACC, qryClaimDetails.DRPT,
qryClaimDetails.[CLAIM#], qryClaimDetails.COV, qryClaimDetails.HANAME,
qryClaimDetails.POLYR, qryClaimDetails.SUBIND, qryClaimDetails.HA,
qryClaimDetails.DESCR, qryClaimDetails.CLAIMANT, qryClaimDetails.STATUS,
qryClaimDetails.CURRES, qryClaimDetails.DCURRES, qryClaimDetails.RESCHG,
qryClaimDetails.SumOfPDLEGAL, qryClaimDetails.SumOfPDLOSS,
qryClaimDetails.SumOfPDOTHEREXP, qryClaimDetails.Incurred,
qryClaimDetails.MEMDED_PROP, qryClaimDetails.MEMDED_TF,
qryClaimDetails.MEMDED_AUTOPHY,
Nz([MEMDED_TF],0)+Nz([MEMDED_AUTOPHY],0)+Nz([MEMDED_PROP],0) AS
MEMDED_PROP_TF_AUTOPHY_TOTAL, qryClaimDetails.MHAPDED_PROP,
qryClaimDetails.MHAPDED_TF, Nz([MHAPDED_TF],0)+Nz([MHAPDED_PROP],0) AS
MHAPDED_PROP_TF_TOTAL, qryClaimDetails.PLSA_PROP,
qryClaimDetails.PLSA_TF, Nz([PLSA_TF],0)+Nz([PLSA_PROP],0) AS
PLSA_PROP_TF_TOTAL, qryClaimDetails.EXPL_PROP, qryClaimDetails.EXPL_TF,
Nz([EXPL_TF],0)+Nz([EXPL_PROP],0) AS EXPL_TF_PROP_TOTAL,
qryClaimDetails.EXLL_GL, qryClaimDetails.EXLL_EPL,
Nz([EXLL_GL],0)+Nz([EXLL_EPL],0) AS EXLL_GL_EPL_TOTAL,
qryClaimDetails.AutoPhyGndUp, qryClaimDetails.PropGndUp,
qryClaimDetails.OtherGndUp, [PropGNDUp]+[AutoPhyGndUp]+[OtherGndUp] AS GNDUP
FROM qryClaimDetails
WHERE (((qryClaimDetails.DACC) Between
DateSerial([Forms]![frmClaimDetail]![cboBeginYear],[Forms]![frmClaimDetail]![cboBeginmonth],1)
And
DateSerial([Forms]![frmClaimDetail]![cboEndYear],[Forms]![frmClaimDetail]![cboEndmonth]+1,0)))
ORDER BY qryClaimDetails.DACC, qryClaimDetails.[CLAIM#];