Conditional Header

I'm trying to generate a reports from a database in which one of the =
fields=20
describes the importance of each record for example the field values =
would=20
be:

Routine, Priority, Urgent

The report needs to contain the highest priority in the header. In =
other=20
words the report may contain several records on a single page, but the=20
header needs to have the highest priority label regardless of how many=20
different priority records are on that page of the report. It's easy =
enough to=20
do if there is only one record per page, but I can't figure out how to =
label=20
the page with the highest priority when there are multiple records per =
page.

Any suggestions? Thanks for your help.

If your report is sorted and or grouped by this 'importance' then just
include the field in the page header. If I am not mistaken, it will show
the value in that field for the first record on the page.

Rick B


"Lee" wrote in message
...
I'm trying to generate a reports from a database in which one of the fields
describes the importance of each record for example the field values would
be:

Routine, Priority, Urgent

The report needs to contain the highest priority in the header. In other
words the report may contain several records on a single page, but the
header needs to have the highest priority label regardless of how many
different priority records are on that page of the report. It's easy enough
to
do if there is only one record per page, but I can't figure out how to label
the page with the highest priority when there are multiple records per page.

Any suggestions? Thanks for your help.

Rick

Thanks, but actually there are several reports and not all are sorted by =

importance the header is just to make the reader aware that somewhere=20
within the page there is data of an urgent nature.

Thanks,
Lee

-----Original Message-----
If your report is sorted and or grouped by this 'importance' then just
include the field in the page header. If I am not mistaken, it will =
show
the value in that field for the first record on the page.

Rick B


"Lee" wrote in message
...
I'm trying to generate a reports from a database in which one of the =
fields
describes the importance of each record for example the field values=20
would
be:

Routine, Priority, Urgent

The report needs to contain the highest priority in the header. In =
other
words the report may contain several records on a single page, but the
header needs to have the highest priority label regardless of how many
different priority records are on that page of the report. It's easy =
enough
to
do if there is only one record per page, but I can't figure out how to =
label
the page with the highest priority when there are multiple records per=20
page.

Any suggestions? Thanks for your help.


.