Access 97

[Kris]

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.

[Jamagei]

*points in direction of the Database Development Forum*

Have got the faintest but you're better off going to a different forum.

[chrisjk]

Simple but effective solution that works on complex queries. Break it into 2 (or more queries), then use a further query to join them together. That's the only way I'm afraid (or simplify the original)