Field name in report title

D

Deanna

Using Access 2003, have a list of registrations with a field for group (1, 2,
3, etc.) Have created a report that will list the attendees in each group
and would like the title to display "Attendance for Group x" where "x" is the
group I have queried.
 
M

Marshall Barton

Deanna said:
Using Access 2003, have a list of registrations with a field for group (1, 2,
3, etc.) Have created a report that will list the attendees in each group
and would like the title to display "Attendance for Group x" where "x" is the
group I have queried.


Try using a text box in the header and set it's control
source expression to something like:
="Attendance for Group " & groupfield

If the group field is name Group, you will probably run into
trouble because Group is a reserved word. Change the name
of the field in the table (and everywhere you use it) to
something else such as RegistrationGroup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top