add expression field to query

[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

 

[John Spencer (MVP)]

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.

 

[mcnewsxp]

i think i discovered that.
don't know why i thought you could.

thanks for verification.