Query exceeds 1,024 character limit

[EddieN1]

I am generating a query from within VBA and, on occasion, the request exceeds the Access 1,024 character limitation for a Query. I know how I can reduce the size of table names by using the AS clause (Tbl_Customer_Address AS CA). Is there a comparable way I can reduce the size of a data element in a WHERE Clause (Customer_Shipping_Address = "AAA" OR Customer_Shipping_Address = "BBB" OR ...) to something like (CSA = "AAA" OR CSA = "BBB" OR ...).

Thanks, Eddie

[June7]

You mean shorter field names? Build a query that constructs fields with an alias. Then use that query as data source.

[EddieN1]

Yes, you can refer to a Column Name (such as Customer_Shipping_Address) with an Alias. For example,

"SELECT Customer_Shipping_Address AS CSA..."