adding yes/no field

[potts]

Is it possible to create a yes/no field to a query? This field does not exist in any of the database tables. If anyone knows how to do this could they show me how?

 

[Pat Hartman]

You can add fields to a query by supplying literal values.

Select fld1, fld2, "Yes" As NewField
From YourTable;

However, these fields are NOT updateable since they do not exist in the underlying table.

 

[potts]

Thanks Pat. I'll just have to find another way round the problem.