Search results for query: *

Hi LB Not sure if its the version I'm using, but having put formula field in detail, then selected insert, summary, the field does not appear in the list for selection.

Hi LB I tried to insert a summary at group level, but the formula for the fields isn't shown in the list. Thanks, Shirley

Hi LB There is a group on month, and it displays the data relevant to each month. It's only when I summarise across the fields that it gives an overall total. Thanks

Hi LB That was my first try, but all it gives me is the total across the whole data, ie if Dec is 15, Nov is 14, Oct is 16, using the formula you mention puts 45 in each of the month sections. Thanks

Hi LB Desired result would be 15 for December Thanks

Hi lb - the report links an Access customer survey db to the main service desk db by a reference number. The Access db has scores against question fields eg Access.Q1, Access.Q2 etc. The resolution date from the service desk db is used to group the responses by month. There is no other...

I have various summaries within a group which I'd like to sum. There are 4 separate field summaries to add, but if I set up a formula it only gives me a grand total, as the fields being counted don't have the relevant date to match the group date. Anyone have any suggestions please? Heres how...