add expression field to query

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
M

mcnewsxp

how do you add a temp field to a query?

i need to add a yes/no field to a query.
i think i got the yes/no part.
just need to know how to use the AS keyword to make it work.
so far all get is a prompt for a parameter.

thanks,
mcnews
 
You cannot add a non-existent field to a query. You can add a calculated value
to a query.

In other words, if I understand your request, you cannot do what you are asking.
 
i think i discovered that.
don't know why i thought you could.

thanks for verification.
 
Back
Top