Recent content by mmckeage

Will try to work up a screen shot, but I guess ultimately, I am asking if there is such an event as a conditional footer, which is active and produces subtotals when a customer has more than one contract, and then is not active and it's height is zero so it doesn't create the space for a...

Thanks. I am also wondering if I can eliminate the spacing generated for the subtotal when the calculations do not get performed (in those cases where the customer only has one contract)?

Thanks for the reply. I think that will work, as this report does not change size. I guess what I really wanted is a conditional back color.

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...

As an interim solution, I created a temporary query that created the following fields: LastYear=[Year]+1 [Peak11] [Peak12] I then created a query that joined my original table's [Year] with the temporary query's [LastYear]. I then used the function provided by pbaldy to find the winter...

Thanks for the quick reply. I acknowledge that the design is not optimal (I am new to this), so any thoughts you might have to improving it would be great. My database has the following fields: Year, Peak1, Peak2, Peak3, ... Peak12 representing the maximum for each month of the year. What I...

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...