For Duane Hookom

[Shirley A. Kerns]

Hi Duane
I may not have given you enough information to deal with my problem
Please have patience with me while I try again

My report fields are: [Book Number] [Book Name] [Circ] & [Cost]
Sorting is by [Book Number] assending order (a must). If the repor
returns for instance 12 records, I need a way to have all cost
evaluated/compared and the top most expensive half (6 in thi
case)appear in bold text without changing the sort order of the boo
numbers. Is such a thing possible

I know some, read everything I can (Access Bible, etc.) and hav
learned mostly through trial and error. This seems over me head
Please help me if you are available

Thank you again
Shirle

 

[Duane Hookom]

Consider a query with SQL like:
SELECT [Book Number], [Book Name], Circ, Cost,
[Cost]>(Select Max(Cost) FROM (SELECT Top 50 Percent * FROM tblShirley ORDER
BY Cost)) AS MoreExpensive
FROM tblShirley;

This should create a column in your query named MoreExpensive with either
a -1 or a 0. Use the value of this field for your conditional formatting.