How to use the Min and Max Functions in Access 2000?

From: Almamba (Almamba_at_discussions.microsoft.com)
Date: 03/27/05 

Date: Sat, 26 Mar 2005 22:55:02 -0800

Hello everybody

I am brand new in Access. I want to create a query to find the lowest and
highest values in a field, using the Expression Builder feature. I found out
that the Max and Min are in the Built-In Functions folder, but I have not
been successful in using them. I will appreciate anybody's help.

Thanks

Relevant Pages

  • Re: Batch importing data for new and updated records.
    ... Use that query to populate your real table. ... > I need to setup a way to import batches of new inventory. ... I cannot import/append to one table as my import data ... > has the actual location names, serial#, model names, and brand names. ...
    (microsoft.public.access.gettingstarted)
  • Re: Sub-form breaks when adding query
    ... I was able to concatenated using a Query, ... > your two tables: Brand and DealDate. ... >>concatenates the first four letters of the brand field ... >>with the dealdate field in the DealStructure table. ...
    (microsoft.public.access.gettingstarted)
  • Re: highest percenatage
    ... Build One query with customer ID, brand, and Count, in another ... this query in your original by customer ID, pull down the brand field. ...
    (comp.databases.ms-access)
  • Re: Enter multiple Parameters for a Field
    ... query only pulls information for that one brand. ... This is what my criteria currently looks like: ...
    (microsoft.public.access.queries)
  • Sub-form breaks when adding query
    ... to see your tables and query. ... your two tables: Brand and DealDate. ... newsgroup, and practice, practice, practice. ... >I have two related tables (Brand and DealStructure) that ...
    (microsoft.public.access.gettingstarted)