Report Look-Ahead Method?

  • Thread starter Thread starter David Habercom
  • Start date Start date
D

David Habercom

My report lists scholarship recipients in the detail section. A campus
code field normally is invisible. 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.

David
 
There is no look-ahead, so the simplest solution might be to get that data
into the RecordSource of the report.

You could do that by joining your query with another one that just returns
the CountOfCampus for each student. You can then use conditional formatting
to set the ForeColor of Campus to white if CountOfCampus = 1.

Post back if you need help on creating that query. It's just a totals query
really. It may be possible to use a subquery, but - depending on the
report - that could run into problems with "multi-level group by not
allowed".
 
Back
Top