Print Page | Close Window

Mode.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
Printed Date: 21 Mar 2018 at 9:59am

Topic: Mode.mdb (intermediate)
Posted By: Roger Carlson
Subject: Mode.mdb (intermediate)
Date Posted: 01 Feb 2011 at 12:08pm
Please consider donating $1 per sample downloaded, - find out why here .
Access has no Mode function, so you have to write one of your own.  This sample database shows how to do that. 

You use the  function  much like the built-in Domain functions (DLookUp, DMax, and so on).  That is, you must provide the 1) field name, 2) table name, and 3) a 'Where' Criteria.  When used in an aggregate query (see below) you MUST add each field 'grouped by' into the Where Criteria.  See Help for more on Domain Aggregate functions.

Access 2000-2010 (mdb) (58 KB): -

Consider donating $1 per sample downloaded," rel="nofollow - find out why here .<

Print Page | Close Window