Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

query help - the sequel



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


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.