AS EXPR 1 or 2???

[Carole]

I am attempting to create a delete query for the first
time and am using a reference as a guide. What does
the "AS Expr1" or "AS Expr2" mean in a query statement?
Any help would be great!

Thanks!

 

[Jeff Boyce]

Carole

If you enter an expression in the Field cell of the query design window, but
don't "prefix" it with a name, a colon, and a space (e.g., "MyNewField: "),
Access will "name" the expression "Expr1" (or Expr2, ...).

Good luck

Jeff Boyce
<Access MVP>