Append Query cutting off memo field

  • Thread starter Thread starter Jenni
  • Start date Start date
J

Jenni

Hello -
I have an append query set up to copy a memo that is
opened in the form and duplicate it exactly.
The memo section is just a large memo field. When the
append query is run, it only copies up to a certain point
of the field and leaves the rest off. I need it to copy
the entire contents of the memo field. Below is the SQL
view of my query. The "Instructions" field is the one
that is that problem area. When users type in this
field, the tend to enter blank lines in the field. Could
this be causing the problem.

Here is my code...

INSERT INTO tbl_qry_addASRMEMOrecords ( ASRTypeID,
Pub_ID, Requestor_Id, Description, Date_Assigned,
Due_Date, Instructions, Instructions2 )
SELECT tbl_ASR.ASRTypeID, tbl_ASR.Pub_ID,
tbl_ASR.Requestor_Id, tbl_ASR.Description, Date() AS
RequestDate, (CalcWorkDays([Date_Assigned],[Due_Date]))
+Date() AS NewDueDate, tbl_ASR_Memo_Details.Instructions,
tbl_ASR_Memo_Details.Instructions2
FROM tbl_ASR LEFT JOIN tbl_ASR_Memo_Details ON tbl_ASR.
[ASR_#] = tbl_ASR_Memo_Details.[ASR#]
GROUP BY tbl_ASR.ASRTypeID, tbl_ASR.Pub_ID,
tbl_ASR.Requestor_Id, tbl_ASR.Description, Date(),
(CalcWorkDays([Date_Assigned],[Due_Date]))+Date(),
tbl_ASR_Memo_Details.Instructions,
tbl_ASR_Memo_Details.Instructions2, tbl_ASR.[ASR_#]
HAVING (((tbl_ASR.[ASR_#])=[Forms]![frm_asr_memo]!
[asr_#]));


Thanks!
Jenni
 
I have an append query set up to copy a memo that is
opened in the form and duplicate it exactly.
The memo section is just a large memo field.
Click to expand...

The problem is that you are Grouping by the memo field - doing so
automatically truncates it to 255 bytes.

I see nothing in your query which requires any grouping - if there
isn't, just unclick the Totals (greek Sigma, sideways-M) tool in the
query design window. This will give you the entire memo field.

If you do need to group for some reason, please post back with an
explanation. You may be able to use First as the Totals operator to
get the value of the memo field in the first record found on disk in
each group, if that's appropriate.
 
Back
Top