Hi,
I have a parameter query which allows the user to enter more then one
value in the parameter box. For example, if they want to know who
took the classes tsa, and opsec, they can enter both of these classes
in the box. (Ilearned to do that from this site with a instr
statement in the criteria box of the query). The report built from
the query works fine. However, I want a header to show each class.
Her's the expression I have in the header section of the report:
="Completion Dates for Course: " & [Class Name]
The results I get for the parameters, tsa and opsec look like this:
Completion Dates for Course: OPSEC
Only the class that would come first alphabetically is in the header.
The other class, TSA is nowhere to be found.
How do I get all of the parameters that the user enters to show in
the header.
Thanks,
Jackie
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/