show a field in a report

[Hermie]

Hello
I have created a report from my unmatched query which shows the group and
names of students who not did a specific task. The report shows all names
and the group selected. Now I want to show on the report the name of the
task the student not made. How can i refer in the report to this field?

Herman

 

[Larry Linson]

If you could clarify the data you have and how you're storing it in tables,
someone would have a much better chance to be of help.

How do you specify the name of the task for your query?

If you are allowing the user to enter it in a Form, you could pick it up
from there in the Open Event of the Report, or the Format event of the
Report or Page header where you want to display/print it in the Report.

If you have a user-entered parameter, perhaps requesting the user with
something like [Enter The Task], and use the query as the RecordSource of
the Report, I believe you can refer to "[Enter The Task]" and retrieve what
the user entered.

Larry Linson
Microsoft Access MVP

 

[Hermie]

Hello Larry

Thanks for your advice. I was focussing on the query to obtain the field
value.Which I think is not possible! I found the solution. Because the
report have a parameterform to enter the parameters and I know that when I
run the report , the parameterform is still loaded in memory. So I created
an unbound text box using the value of the combobox. Control source in
textbox is: = paramform!cbotarea.column(1) and this works great now.

Herman

If you could clarify the data you have and how you're storing it in tables,
someone would have a much better chance to be of help.

How do you specify the name of the task for your query?

If you are allowing the user to enter it in a Form, you could pick it up
from there in the Open Event of the Report, or the Format event of the
Report or Page header where you want to display/print it in the Report.

If you have a user-entered parameter, perhaps requesting the user with
something like [Enter The Task], and use the query as the RecordSource of
the Report, I believe you can refer to "[Enter The Task]" and retrieve what
the user entered.

Larry Linson
Microsoft Access MVP

Hello
I have created a report from my unmatched query which shows the group and
names of students who not did a specific task. The report shows all names
and the group selected. Now I want to show on the report the name of the
task the student not made. How can i refer in the report to this field?

Herman