AS EXPR 1 or 2???

  • Thread starter Thread starter Carole
  • Start date Start date
C

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!
 
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>
 
Back
Top