Report Look-Ahead Method?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report lists scholarship recipients in the detail section. Sometimes the
list contains student names from more than one campus. In those cases -- and
only those cases -- I would like to make the campus code visible. How do I
get the format process to look ahead and determine whether the list will
contain more than one campus code? Thanks.
 
You need to create another query that counts the number of campi per
recipient. You can then add this query to your report's record source and
use an expression like
=IIf([CountOfCampus]>1,[CampusCode],"")
 
Back
Top