Too long of query, way to store statements?

[btappan]

I have a query I'm trying to make in access expression builder that is very long. It is used to concatenate columns in a table to create product descriptions based on the field "product type". based on the product type, the concatenation expression changes. Because there are many product types, the expression is quite long and exceeds the character limit of the expression builder. Is there a way to store parts of the expression and call them by a name or number reference? Like: if product type is widget, use expression A, and expression a could be stored somewhere else? I don't know vba or anything.

[ItsMe]

I usualy manage such tasks with VBA.

[NTC]

One can make a query using design view, using another query as its table/source. This method can be repeated over and over. It allows very complex queries to be segmented into a series of individual queries. The primary benefit of this approach is that one can run each/any individual query by itself for troubleshooting purposes.....

Once it works - one only that calls or refers to the final query alone - - and all subsequent related sub queries run automatically...

[ssanfu]

It is used to concatenate columns in a table to create product descriptions based on the field "product type". based on the product type, the concatenation expression changes. Because there are many product types, the expression is quite long and exceeds the character limit of the expression builder.

It sure sounds to me like you do not have a normalized table structure.
I'm just saying....