Link to home
Create AccountLog in
Avatar of pdvsa
pdvsaFlag for United States of America

asked on

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

User generated image
Avatar of pdvsa
pdvsa
Flag of United States of America image

ASKER

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;
Avatar of Joe Howard
Read this for the 6 most common reasons http://allenbrowne.com/ser-63.html
Avatar of pdvsa

ASKER

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
Look in the workarounds column.
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of pdvsa

ASKER

Hi GUSTAV, thank you very much.  I will try it and hopefully it only looks more difficult that it is...

Have a good day
Thanks! You will manage, I'm sure.

/gustav