Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to take three fields in a table that contain numbers. I would like to find the sum of the two largest numbers of these three numbers. I would like to do this in a query
Thanks
 
Even if it is possible to use Query alone, it will be very
complicated. It is much better to write a (VBA) UDF (User-
Defined Function) to accept 3 numbers and returns the sum
of the 2 bigger number and you can create a simple Query
using this UDF to return what you want.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
I would like to take three fields in a table that contain
Click to expand...
numbers. I would like to find the sum of the two largest
numbers of these three numbers. I would like to do this in
a query.
 
Back
Top