Search results

Hi All, I would like to change the background color of a footer, in the event that such footer has data. I am using this footer to generate a subtotal, if a customer has purchased more than one item- if only one, then the subtotal doesn't show up. So in the case where Count = 1, the report...

Hi all, I am trying to write an Access query that will return the maximum of several fields. As an example, I have four to ten salespeople who have earnings each week. I want to say "TopSalesPerson=Max(Sales1,Sales2,Sales3...)". If this was Excel, I would type in cell A11 Max(A1:A10). Is...