Add text on the form when the query is "shown"

[XXD]

Add text on the field when the query is "shown"

I have created query that shows some fields from selected tables. The information that shows from all fields, when I "run" the query can't be edited and I can't add new text on the bottom of field. How can I do this?

I have attached a picture of my query. You maybe understand better if you see it.
Will appreciate it alot. Need help very quickly.

 

[ajetrumpet]

The thing that comes to mind initially is the fact that you say the query is not editable.

As a general rule, Queries cannot be edited if they contain groupings, aggregate functions, subqueries, or JOINS.

I know for a fact that if you initiate a query that violates the above rule, you will see that button that you have pointed to, grayed out.

 

[XXD]

OK... so you cant add any new text on a query?

 

[cooh23]

OK... so you cant add any new text on a query?

You can, try editing your relationship and click on Join type. I know that it probably violates the rule but it works for me. Choose number 2. then hit ok.

Just play around with it.

 

[boblarson]

Read this for info on what makes a query non-updateable:

http://allenbrowne.com/ser-61.html