Hard Coded Dymanic Fields

[paulS30berks]

Having one of those days!!!

I have a simple query populating fields from 2 tables and would like to add a further field to my query (not in tables)

In this field I wish to hard code in 2 values. Can anyone suggest the best way of doing this?

Thanks

Paul

 

[Jibbadiah]

If you wanted to create a field called field1 with text of "hello", you would just add

Field1: "hello"

to your query.

If you are using the query to populate a form, then you could just add an unbound text control with a default value, or even a label.

If you were considering storing these values please read up on normalisation rules first - there are many posts in this forum.