Re: how return max value from one of three "fields" in a query?

See the MaxOfList() function here:
http://allenbrowne.com/func-09.html

In general, if you are comparing values across fields, it is worth
considering whether it would be better to create a related table where these
can be multiple records instead of having multiple fields in one table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ginycub22" <Ginycub22@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

news:D7290960-C6B0-4B86-9BEA-FB370A480ECC@xxxxxxxxxxxxxxxx
I am running a query to compare 3 fields and I want only the information in
the field with the highest number displayed in the output.


.

Relevant Pages

  • Re: how good are these cranks?
    ... Depends on what you're comparing them to as well? ... It might be worth your while sending them back? ... I've taken them on some light muni and light hops and they are good ... enough for me (as a beginner, and only weighing 120ish lbs) but not ...
    (rec.sport.unicycling)
  • Re: Circus/Circus
    ... so the real question is the quality of the rooms. ... Comparing CC to Bally's is like comparing Compton to Beverly Hills - ... which to me would still not be worth it. ...
    (alt.vacation.las-vegas)
  • Re: Garmin 596 at OSH?
    ... That refresh rate - and its impact upon the pseudo-panel - ... would be worth the $1000 to me (whereas the other "extra" features aren't). ... But I'm still hoping to hear/read of people comparing the 496 to the ...
    (rec.aviation.piloting)
  • Re: Computing electric costs
    ... He is talking to supliment heat thinking electric is cheaper, so cost ... comparing the 2 sources is all he needs to know if its worth looking ...
    (alt.home.repair)