>What exactly is this error message telling me?
>
>SQL: statement too long
>
>Does is mean that I have too many fields in my record and can no longer be updated? Do I need to create a new table for any additional fields?

It sounds like you've exceeded 254 fields allowable in a SELECT statement.