Query truncating memo field - doesn't appear to be any of the usual culprits

[caki2112]

Greetings,



I'm new to the forum, so please forgive any breaches of etiquette and let me know so I can avoid them in the future.

I'm having trouble with a query that is truncating a memo field. I found Allen Browne's list of reasons this can happen, and I'm pretty sure none of them apply in this case...I'm not messing with totals, I don't have anything in the field's format property, I'm not concatenating, I'm not using a unique query, and while I'm not sure what a union query is, I'm pretty sure I'm not doing that either since the word "union" does not appear anywhere in the SQL. I have verified that the table the field comes from is using a memo field. Any thoughts?

Here is the SQL statement:

SELECT ALUMNI_APRCONF.APRCONF_PIDM, ALUMNI_APRCONF.APRCONF_COMMENT AS [DNC Comment]
FROM ALUMNI_APRCONF INNER JOIN ALUMNI_APRSUBJ ON (ALUMNI_APRCONF.APRCONF_PIDM = ALUMNI_APRSUBJ.APRSUBJ_PIDM) AND (ALUMNI_APRCONF.APRCONF_IDEN_CODE = ALUMNI_APRSUBJ.APRSUBJ_IDEN_CODE) AND (ALUMNI_APRCONF.APRCONF_GRP_SEQ_NO = ALUMNI_APRSUBJ.APRSUBJ_GRP_SEQ_NO)
WHERE (((ALUMNI_APRSUBJ.APRSUBJ_SUBJ_CODE)="DNC"));

Laurie

[June7]

No idea. Query looks good. Want to provide db for analysis? Follow instructions at bottom of my post.

[caki2112]

Thanks for your response. In looking through my data to find good examples to leave in the database when I shared it, I discovered that although the field appeared truncated when I looked at the query in Access, it actually wasn't when I exported the data to Excel. This seems odd to me, but ultimately isn't a problem. I traced the source of the truncation that was appearing in my final product to a different query that did have a totals row. Removing that fixed the problem. Now I just have to go find the instructions for marking a thread solved. =) Thanks again.