Recent content by Lulu3

Thank you for this - you've been very helpful.

I would like to highlight the top three scores in each of my column headings of the report's underlying crosstab table (Fieldname: QuarterWk in the uploaded DB. There are 13 in total). In my sample DB I have only set up conditional format for the first 5 columns so far as described above (using...

I just want the top three fields in each column highlighted, not the whole row, as numbers vary for each country in each column. At the moment I have set it as - top score in purple, anyone else above average in green, so two different conditional formats per field.

Hi thanks that's great. I have attached it - the report is called nats. It's not fully finished yet, but hopefully you'll get the idea.

Thanks, I've done that - the problem is although it highlights the top three countries, they are the same for each of my 13 columns (Date). Also, these are the countries with the highest number of students overall, not the highest number of students per week. I have now worked out the average...

Thanks for the quick reply. I've tried to do what you suggested, but I don't think this works for me. Maybe I have misunderstood, but your suggestion would highlight all values where there are students, however, I was looking to only highlight the three highest numbers in each column. I have...

Hi thanks for that. I think I sort of see what you mean, but I'm not sure if this will work in my case. The query in step 1 is a crosstab query, giving me a nationality breakdown for 13 different dates (13 columns), and it looks like this: country Date1 Date2 Date3 etc... Austrian...

yes that's correct. I am using a crosstab query as the underlying data, and the date fields are in the column headings. The nationality field is a row heading, and sorted in alphabetical order. It is a quarterly analysis, so there are 13 dates (fields) going across, and for each date I would...

Hi I am just in the process of creating a report which gives the weekly breakdown of nationalities in our language school. I have managed to highlight the highest value each week by using the MAX function, however, I would like the top three nationalities to be highlighted in the same...

Hi I'm new to this forum and I look forward to learning lots more about Access.