
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
Ok - I managed to overcome my daftness this morning and get my query to work. I have one last step to conquer and victory will be mine!!!! muah hah hah hah!!! How can I get my report to display the smallest number returned in the list of my query results? My query returns [Generators].[GeneratorKw] (a number field) where [Generators].[GenStartWatt] is >= [qryTotalSumStartWatts].[TotalSum] My goal is to display in the report the smallest instance of [Generators].[GeneratorKw] or - if no records meet the criteria, the smallest GeneratorKw in the Generators table. I hope this makes more sense than my last post which seemed logical to me last night - but this morning? A different story. Again - thanks in advance for any help. Brian
| <-- __Chronological__ --> | <-- __Thread__ --> |