Field being truncated - memo field

Experts,

I have a table: import_excel
I have a query built off of this table: qryDuplicates_Removed (that removes duplicates)

Why would the qry truncated the field [Deliverable] whereas this same exact field in the table import_excel is not truncated?  

thanks

Truncated
pdvsaProject financeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pdvsaProject financeAuthor Commented:
if you wish to see the sql of the Duplicates_Removed qry:

SELECT First(Import_Excel.ID) AS OneID, Import_Excel.Deliverable, Import_Excel.Frequency, Import_Excel.[Section Referenced], Import_Excel.Timing, Import_Excel.[End or Start Date comments], Import_Excel.Agreement, Import_Excel.Comments, Import_Excel.[Area of Responsibility], Import_Excel.Description, Import_Excel.Receivor
FROM Import_Excel
GROUP BY Import_Excel.Deliverable, Import_Excel.Frequency, Import_Excel.[Section Referenced], Import_Excel.Timing, Import_Excel.[End or Start Date comments], Import_Excel.Agreement, Import_Excel.Comments, Import_Excel.[Area of Responsibility], Import_Excel.Description, Import_Excel.Receivor;
0
MacroShadowCommented:
Read this for the 6 most common reasons http://allenbrowne.com/ser-63.html
0
Gustav BrockCIOCommented:
Well-known issue.
You can use the technique here:

http://www.experts-exchange.com/Database/MS_Access/Q_28554757.html#a40434530

/gustav
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

pdvsaProject financeAuthor Commented:
OK I see it is an issue with Access and not me.  For once I am not wrong!  Wow!  I only spent 1 hour figuring that out.  

Gustav, I see you have provided a work around.  

Macroshadow:  I don't see a solution though.

Gustav:  how would I call that function?  I read your post in the other question and I will create a new module etc etc.  

thank you
0
MacroShadowCommented:
Look in the workarounds column.
0
Gustav BrockCIOCommented:
Like the in-line comment:

    SELECT
        ID,
        LookupMemo("Table1", "ID", "MemoField", [ID], [MemoField]) AS FullMemo
    FROM
        Table1;

However, as you have no id and want only the distinct note field (Deliverable) values, Thus make a Group By on the first 255 characters of Deliverable, I would alias the field:

    Import_Excel.Deliverable As Deliverable255

and otherwise leave that query as is, and then create a second using the first as source.
Could be:

    SELECT
        OneID,
        Deliverable255,
        Frequency,
        [Section Referenced],
        Timing,
        [End or Start Date comments],
        Agreement,
        Comments,
        [Area of Responsibility],
        Description,
        Receivor,
        LookupMemo("Import_Excel", "ID", "Deliverable", [OneID], [Deliverable255]) AS Deliverable
    FROM
        YourFirstQuery;

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pdvsaProject financeAuthor Commented:
Hi GUSTAV, thank you very much.  I will try it and hopefully it only looks more difficult that it is...

Have a good day
0
Gustav BrockCIOCommented:
Thanks! You will manage, I'm sure.

/gustav
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.