How to get the calculated column to find a min value for a given field?

advertisements

I have a MS Access DataBase with a table as shown below

Col A    Col B  Computed Col
Apple    10      10
Apple    20      10
Apple    15      10
Orange   10      5
Orange   5       5
Orange   23      5
Orange   25      5
Grapes   40      30
Grapes   45      30
Grapes   30      30

I want to have a computed col i the query to find the min value for the fruit Please help

The min() function isn't supported in calculated fields in Access. I would just query for it as

   SELECT fruits.fruitname ,min(numfruit) as minimum
 FROM fruits GROUP BY Fruitname

Related Articles

Autolayout how to get the calculated value from the view

There is one thing that is really making me crazy about auto layout , I'm doing my tests and found that if you subclass a UIView and you put some views with their constraints is impossible to know the computed value. Let't say that we have a TestView

Excel VBA: How to check the calculated column?

Is there anyway to check in VBA if a specific column of a table (ListObject) in Excel is a calculated column (as in http://office.microsoft.com/en-us/excel-help/use-calculated-columns-in-an-excel-table-HA010342380.aspx)? Note that calculated columns

how to get the modified column name in the tables

if we want to get the changes happened in database we will get through sys.objects or sys.tables .but we are only getting it table name . But how to get by table name and what the column added to that table or what column has been modified (datatype

How to get a calculated column in Linq To SQL

We are using Linq To SQL with our own data context logic that executes the one linq query across multiple databases. When we get the results back, we need the database for each of the rows. So... I want to have a property on my class that will return