Splitting big table to smaller ones

[UserError]

Hello,
I have inherited a database with in excess of 78 fields and I gather I need break this down as it may be causing the "record is too large" error. There are sections which lend themselves to this: there are field prefixed "susc", "val" and "vis" but I can't see how to select these in a query.
I could add all the fields and choose only the ones I want but that seems a but primitive. There must be a more efficient way?
Many thanks

 

[UserError]

Hi UncleGizmo, Thanks, this is a large landscape assessment database with many justifiable/valid fields (assessment of many characteristics of the landscape). It may once have originated in Excel and possibly outgrew it, but I know as a database it has been used like this on previous occasions. There are a number of H/M/L fields that (I put) in combo boxes/tables but in this version there are no Y/N (although the version I was sent has loads of these, so I would be interested in reconfiguring those so will PM you about your offer, thank you.
In the meantime, I copied the SQL into Notepad++ & edited the text with find/replace then pasted it back in as a workaround