query help - the sequel -
11-18-2003
, 08:12 AM
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 |