How to compare fields

From: Luther <Luther@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 12 Sep 2005 08:31:04 -0700

Hi,

I need to compare three numeric fields and pick the greater of the three; I
will then have to use that number in subsequent calculations.

Any help with this will be greatly appreciated.

Thanks.
.

Follow-Ups:
- Re: How to compare fields
  - From: John Spencer (MVP)
- Re: How to compare fields
  - From: John Vinson
- RE: How to compare fields
  - From: Ofer
- RE: How to compare fields
  - From: Ofer

Prev by Date: Re: Time Schedule Query - Eric D
Next by Date: Store Procedure
Previous by thread: Syntax ^'(ctrl + ')
Next by thread: RE: How to compare fields
Index(es):
- Date
- Thread

Relevant Pages

Re: How to compare fields
... >I need to compare three numeric fields and pick the greater of the three; ... >will then have to use that number in subsequent calculations. ... Prev by Date: ...
(microsoft.public.access.queries)
RE: How to compare fields
... > I need to compare three numeric fields and pick the greater of the three; ... > will then have to use that number in subsequent calculations. ... Prev by Date: ...
(microsoft.public.access.queries)
RE: How to compare fields
... "Ofer" wrote: ... >> I need to compare three numeric fields and pick the greater of the three; ... >> will then have to use that number in subsequent calculations. ... Prev by Date: ...
(microsoft.public.access.queries)
RE: How to compare fields
... Good luck ... > I need to compare three numeric fields and pick the greater of the three; ... > will then have to use that number in subsequent calculations. ... Prev by Date: ...
(microsoft.public.access.queries)
Re: how to compare date
... Date/time fields in Access are really numeric fields of type Double, ... by default formatted as some date format for display, ... if you want to compare ...
(microsoft.public.access.queries)