Access Error - String returned by builder was too long - the results will be truncated.

[datachick]

Please look at this syntax. I don't know why the query is truncating.Attachment 19838

LINE_ID:IIF((Mid([TBL_A]![PD_ID], 4, 1) = “Q”) OR (Mid([TBL_A]![PD_ID], 4, 1) = “Q” AND ACPT_DTM < #03-01-2015#),”ORH”,
IIF((Mid([TBL_A]![PD_ID], 4, 1) = “A”) OR
(Mid([TBL_A]![PD_ID], 4, 1) = “A” AND ACPT_DTM < #03-01-2015#),“ORP”,
IIF((Mid([TBL_A]![PD_ID], 4, 1) = “C” AND [TBL_B]![CS_ID] = “DC20016”) OR
(Mid([TBL_A]![PD_ID], 4, 1) = “C” AND [TBL_A]![ACPT_DTM] < #03-01-2015#) OR (Mid([TBL_A]![PD_ID], 4, 1) = “F” AND [TBL_B]![CS_ID] IN (“DAL20016”,”DD20016”,”DF20016”,”DJ20016”)) OR (Mid([TBL_A]![PD_ID], 4, 1) = “F” AND [TBL_A]![ACPT_DTM] < #03-01-2015#),”ORC”,
IIF((Mid([TBL_A]![PD_ID], 4, 1) = “C” AND [TBL_B]![CS_ID] IN (“HA20036”,”H220036”)) OR ((Mid([TBL_A]![PD_ID], 4, 1) = “F” AND [TBL_B]![CS_ID] = “HB20036”),”ORA”,IIF((Mid([TBL_A]![PD_ID], 4, 1) = “P” AND [TBL_B]![CS_ID] = “LM20024”) OR (Mid([TBL_A]![PD_ID], 4, 1) = “X” AND [TBL_B]![CS_ID] = “OB20026”), “ORN”, “Unknown”)))))

[June7]

Must have hit some limit, maybe: Number of characters in a cell in the query design grid - 1024.

Review:

https://support.office.com/en-US/Art...rs=en-US&ad=US