A query to output custom text?

[Nature]

Hi all, is there any way I can setup a query to output custom text?

eg.
col. 1 output field name
col. 2 output field age
col. 3 output "New Student"

"New Student" is the custom text I would like to generate everytime. I know
I can make a field with "New Student" filled for all records, but it looks
redundancy to me.

Thanks in advance!

 

[Guest]

Hey Nature, not sure exactly if this is what you want. But if you go to the
text box that you want "New Student" to show up... just go to the properties
of the text box and under control source type

="New Student"

It will show up every time.

 

[Arvin Meyer [MVP]]

If this will display in a form or report, I'd leave the control unbound and
use a conditional to decide if it's a New Student, or not. If you are using
it in a query for another reason, just add a column name (alias) and New
Student, like:

Col3: "New Student"