Re: How to find Minimum of four fields


Jeff Boyce wrote:
As others have pointed out, your data design is not optimized for what
Access can do. If you feed Access '*** data, you won't get the best of
its features and functions.

If you provide a bit more detail about what you are storing in those four
fields, the newsgroup readers may be able to offer suggestions about
improving the table design (and hence be better able to use Access'
strengths).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"galsaba" <galsaba@xxxxxxx> wrote in message
news:1166132130.669605.308720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
If I tried Excel? I did not becuase I know it will work...
I need it in access as part of big application with table relations and
other features that Excel does not have.

I need it in Access

Thanks

galsaba
Jeff Boyce wrote:
If you are trying to find a minimum value across four fields, it sounds
like
you have a spread***. Have you tried using Excel?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"galsaba" <galsaba@xxxxxxx> wrote in message
news:1166121059.297139.185330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a table with four field (column) what wil be the way to find the
minimum?
does access provide a function to do so?
does MS VBS provides?
thanks

galsaba


say i have a store , and I have 4 option of how to seel an item. web,
phone, store, show.
each one will have adifferent cost of sale for me, based on many
inputs. there is a list of items, that's ehy i think the "my cost
selling by web", "cost selling by phone", etc should be columns, and
the items are the rows.

galsaba

.