Search results

Thanks so much for the very quick response. This has taken me a bit further, but my problem is not solved. My question becomes, can DAvg be used at the group level and, if so, how? Access seems to just "know" that other group level totals are to be calculated at the group level, based only on...

I want to define subtotals (specifically averages) in a grouped report, but I want to exclude values over 199 from the calculation. It appears that DAvg should achieve this but it actually produces some very odd results (but does not give an error message). Should I be able to use DAvg to do...

I have a combo box with a simple 2-option value list. In the lookup tab in the field properties box, I have the Row Source Type set to Value List, and the Row Source set to "xxxxx";"yyyyy". I have set "Limit to List to Yes". But, on the Form, although up and down arrows show in the data entry...