Solved Append Query not copying all data from memo field

[murray83]

Hi All

have a slight issue and have searchd and it seems like it's a known bug, but cant find any fixes

so have a table which has a memo field and is set ot rich text, which is fine as it shows all information as it should

but then i have an extract data table as we need to run a report each week so need to quick put in a date and then show data for that day, but the error is this; even though the extract data table also has the same field ( as its append ) set to memo and rich text it cuts of some of the data

please see attached for example any help would be greatfully apperciated

 

[theDBguy]

Can we see your append process please?

 

[murray83]

Of course

 

[theDBguy]

Thanks. If you change that append query to a select query, is the memo field truncated?

 

[murray83]

Thanks. If you change that append query to a select query, is the memo field truncated?

Afraid so see below attached showing the results and the query changed from append to select

 

[murray83]

Fixed it, yippeee

all i had to do was view the SQL and remove the DISTINCT from the below so now it looks like this

INSERT INTO tblExtractData
SELECT tblChargingTable.*
FROM tblChargingTable
WHERE (((tblChargingTable.AppointmentDate) Between Forms!frmMain!txtChooseFrom And Forms!frmMain!txtChooseTo) And ((tblChargingTable.SupplierCode)<>"CSHC001"));

 

[theDBguy]

Fixed it, yippeee

all i had to do was view the SQL and remove the DISTINCT from the below so now it looks like this

INSERT INTO tblExtractData
SELECT tblChargingTable.*
FROM tblChargingTable
WHERE (((tblChargingTable.AppointmentDate) Between Forms!frmMain!txtChooseFrom And Forms!frmMain!txtChooseTo) And ((tblChargingTable.SupplierCode)<>"CSHC001"));

Ah, that's the piece we can't see from the images. I was looking for Group By but didn't see them.

Good luck with your project.