I have an Access 2003 form that is displaying the error: "This form or report is based on a query that exceeds the limit for data in a single record"
When I go to the actual query and enter the itemnumber it gives me the error, if I enter another item the query runs.
The query pumps out 172 fields, I've been reading around and I think it's because the query can't pump out more that 2000 characters per row. Is this true? If so, how can I get this to work?
Thank you in advance!