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
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