Beginner Alert!!!
When I try using the Memo datatype as a parameter in my append query it tells me I "need to remove the DISTINCT keyword, memo field or OLE object when selecting unique values" or something to that effect. I changed the query to unique records, Top Values to 1 to eliminate duplicates(???)and set the parameters as memos.
The query is still truncating the form data before it gets to the table and the error message occurs on some specific fields.
Very frustrating issue. Any suggestions??
When I try using the Memo datatype as a parameter in my append query it tells me I "need to remove the DISTINCT keyword, memo field or OLE object when selecting unique values" or something to that effect. I changed the query to unique records, Top Values to 1 to eliminate duplicates(???)and set the parameters as memos.
The query is still truncating the form data before it gets to the table and the error message occurs on some specific fields.
Very frustrating issue. Any suggestions??