Search results

Hi, Can someone please help. I am required to bring back a ranadom 10% of data where the [Total_Cost] field is less than £500. Can this be done in one query? I have to use Access97 becuase this is the lowest Office Version we support. :confused: .

Conditional Formatting isn't an option becuase I have to support MS Access97 with this. I currently use code in report groups to format specific results. Specifically preformance reports that are grouped by Green 90-100% Amber 75-89% Red 0-74% This works fine while printing and...