Formula in a Query

[Guest]

Are there any restrictions while entering Expressions into a Query.

ie. character length or a certain amount of functions per column

Travis

 

[John Vinson]

Are there any restrictions while entering Expressions into a Query.

ie. character length or a certain amount of functions per column

Yes. See "Specifications" in the online help:

Number of characters in a cell in the query design grid 1,024

Number of characters in an SQL statement approximately 64,000

To avoid hitting this error, step back and reanalyze your problem: if
you need an expression over 1024 characters long, there's GOT to be a
simpler way! For instance, if you're doing a complicated nested IIF(),
consider using a table-driven solution joining another table into the
query, rather than embedding a lot of values into the expression.

John W. Vinson[MVP]

 

[fredg]

Are there any restrictions while entering Expressions into a Query.

ie. character length or a certain amount of functions per column

Travis

See Access Help:
Specifications + Access Specifications + Query

 

[Guest]

Thanks you. I tried using the online help before using this but I didn't know
what to look under. But "specifications" will help.
Thanks again.
Travis