I have a question about Access 97. I have developped an application in Access 97 but I encountered a problem. I am creating a report based on a serious query (that contains a large amount of tables). When I execute the query the correct result returns, but when I try to save it Access says that the expression is too long and it'll be shortened. How can I solve this problem. Isn't it possible to make a query that is longer then a certain amount of characters ?

Can somebody help me out.

Thanks in advance,

Kris.