We are currently running a MS Access DB at the company I work for, and recently this error pops up when we try to collect data through queries:<BR> <BR>"The field is too small to accept the amount of data you attemted to add. Try inserting or pasting less data."<BR> <BR>This error message is generated through this line of code:<BR> <BR>SELECT distinct nova.category, nova.heading from nova;<BR> <BR>So my question is: Would there be another way to re-write the SQL statement above so that this error is not generated? Thanks.<BR>