enter parameter value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i did a iff ( if x value = x value,Y,N) then i tray to use"Y" like a criteria
in the colum. When i run the qry i get the message "enter parameter value"
 
SELECT dbo_CMC_CLCL_CLAIM_1.CLCL_ID, dbo_CMC_CLCL_CLAIM_1.CLCL_CUR_STS,
dbo_CMC_CLCL_CLAIM_1.CLCL_LAST_ACT_DTM, dbo_CMC_CLCL_CLAIM_1.CLCL_INPUT_DT,
dbo_CMC_CLCL_CLAIM_1.CLCL_RECD_DT, dbo_CMC_CLCL_CLAIM_1.CLCL_ACPT_DTM,
Year([CLCL_INPUT_DT]) AS acpt, Year([CLCL_PAID_DT]) AS paid,
IIf([acpt]<>[paid],1,0) AS [Yes/No], dbo_CMC_CLCL_CLAIM_1.CLCL_PAID_DT INTO
[RECLAM_PAID DATE]
FROM dbo_CMC_CLCL_CLAIM AS dbo_CMC_CLCL_CLAIM_1;
 
I suggest you don't use derived columns for other purposes in your query.
Try:
SELECT dbo_CMC_CLCL_CLAIM_1.CLCL_ID,
dbo_CMC_CLCL_CLAIM_1.CLCL_CUR_STS,
dbo_CMC_CLCL_CLAIM_1.CLCL_LAST_ACT_DTM,
dbo_CMC_CLCL_CLAIM_1.CLCL_INPUT_DT,
dbo_CMC_CLCL_CLAIM_1.CLCL_RECD_DT,
dbo_CMC_CLCL_CLAIM_1.CLCL_ACPT_DTM,
Year([CLCL_INPUT_DT]) AS acpt,
Year([CLCL_PAID_DT]) AS paid,
IIf(Year([CLCL_INPUT_DT])<>Year([CLCL_PAID_DT]),1,0) AS [Yes/No],
dbo_CMC_CLCL_CLAIM_1.CLCL_PAID_DT
INTO
[RECLAM_PAID DATE]
FROM dbo_CMC_CLCL_CLAIM AS dbo_CMC_CLCL_CLAIM_1;

--
Duane Hookom
MS Access MVP


Question said:
SELECT dbo_CMC_CLCL_CLAIM_1.CLCL_ID, dbo_CMC_CLCL_CLAIM_1.CLCL_CUR_STS,
dbo_CMC_CLCL_CLAIM_1.CLCL_LAST_ACT_DTM,
dbo_CMC_CLCL_CLAIM_1.CLCL_INPUT_DT,
dbo_CMC_CLCL_CLAIM_1.CLCL_RECD_DT, dbo_CMC_CLCL_CLAIM_1.CLCL_ACPT_DTM,
Year([CLCL_INPUT_DT]) AS acpt, Year([CLCL_PAID_DT]) AS paid,
IIf([acpt]<>[paid],1,0) AS [Yes/No], dbo_CMC_CLCL_CLAIM_1.CLCL_PAID_DT
INTO
[RECLAM_PAID DATE]
FROM dbo_CMC_CLCL_CLAIM AS dbo_CMC_CLCL_CLAIM_1;


Duane Hookom said:
Please share your sql.
Click to expand...
Click to expand...
 
Back
Top