Top 50% in bold on a report

[Shirley A. Kerns]

Hello to all
How can I get a reprt that returns X number of records to display th
top 50% in bold? I am sorting in descending order by cost. I hav
created a query that does this for me but when I use this query for
subreport it only shows the top 50% of records. Is a subreport eve
needed? I need all records to show but only the top 50% to appear i
bold text. Using conditional format on the report requires a
expression that I lack the ability to create. Can I just create th
formula in the properties of the text block? If so, how do yo
express that
Thank you in advance
Shirle

 

[Duane Hookom]

Assuming your report is printing in order, you can:
-add a text box
Name: txtRunSum
Control Source: =1
Running Sum: Over All
-Select a control to format
-Select Format->Conditional Format
-Choose "Expression Is"
-Enter this expression
[txtRunSum]<Count(*)/2
-Set the appropriate formats
-Click OK
-Preview Report

 

[Shirley A. Kerns]

Hi Duane
Thanks for your speedy response
This worked to a degree. What I got when I ran the report was
descending list starting with the number 1 and ending with the las
recordset of 12. The top 6 records with the new text block wer
displayed in bold as needed. The problem is, it's not the fiel
needed to display in bold. Did I missunderstand? The field name i
[Cost]. How can I reference it to the field name of [Cost]? Can I d
it in the Conditional Format formula
Thank you so much for your help
Shirle

 

[Duane Hookom]

When I stated "-Select a control to format" I didn't mean the new text box.
This could be any one of the controls in your report.