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/
 


Reply via email to