Adding Static Fields To A Select Query

[paul29berks]

I wish to add a static field to a select query i.e a field that does not exist within a table.

Does anyone know how I can do this?

Thanks

 

[nullZero]

yes, just type it into the field row. If it's text make sure to put quotes around it, if it's a date wrap it in pound signs, and if it's a number then you don't have to do anything.