FatherJack
Programmer
I am trying to create a report that compiles data from 4 tables. there are approx 290 records returned in the recordset with 48 fields involved (many yes/no, others text). The query runs quite happily but the report returns 'run time error 7799' - "this form or report is based on a query that exceeds the limit for data in a single record"
does any one know of a way around this ? I have tried changing the table properties from text to memo as the help suggests but it makes no difference.
Please help - I have to produce the report. [sig][/sig]
does any one know of a way around this ? I have tried changing the table properties from text to memo as the help suggests but it makes no difference.
Please help - I have to produce the report. [sig][/sig]