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],"")
 

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

Similar Threads

Report Look-Ahead Method? 1
Count unique students at report footer 2
Formatting Data 1
Help sorting report by calculated field in a group footer on repor 2
Assistance with Concatenate function 2
Query Problem - Design Problem? 5
How to print a page in between of every report page? 3
Report containing multiple critera/filters 6

Back
Top