Top Articles

Median, Mode, Skewness, and Kurtosis in MS Access

matthewspatrick02/24/2010, 12:00 AM

by Patrick G. Matthews Introduction Like other database applications, Access provides support for computing basic descriptive statistics for a data set, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance

Topic: Microsoft Access DatabaseTags: Microsoft, Access, Statistics, Mean, Median, Mode, Standard Deviation, Skewness, Kurtosis, Sampling, Visual Basic, Visual Basic for Applications, VBA

Views: 15728Comments: 23

Calculating Distinct Counts in Access

matthewspatrick02/08/2010, 12:00 AM

by Patrick G. Matthews All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception.  As in other database platforms, Access's Count() (as well as the "domain aggregate" DCount()) function returns t

Topic: Microsoft Access DatabaseTags: Access, Query, Queries, SQL, Distinct, Count, Distinct Count, VBA, Visual Basic, Aggregate, Domain Aggregate

Views: 13412Comments: 18

How to Mimic the T-SQL IsNumeric() Function in MySQL

mwvisa111/21/2008, 12:00 AM

In database programming, custom sort order seems to be necessary quite often, at least in my experience and time here at EE. Within the realm of custom sorting is the sorting of numbers and text independently (i.e., treating the numbers as number

Topic: SQL Query SyntaxTags: MySQL, IsNumeric, RegExp, Regular Expression, Sorting Text and Numbers Separately, SQL, RegExp_Like

Views: 9737Comments: 28

Expanding a Hierarchical Data Structure

mbizup06/20/2008, 12:00 AM

Introduction One of the earliest concepts learned by database developers is parent-child (one-to-many) relationships.  These relationships are integral in countless database applications.  A purchase request containing one or more items ordered i

Topic: Microsoft Access DatabaseTags: Databases, MS Access, Bill of Materials, BOM, Parts Lists, heirarchical, recursion

Views: 8701Comments: 42

Simple Linear Regression in MS Access

matthewspatrick04/03/2010, 12:00 AM

by Patrick G. Matthews Introduction Linear regression analysis is a common statistical technique used to infer the possible relationships between a dependent variable and one or more independent variables.  While Microsoft Access does not

Topic: Microsoft Access DatabaseTags: Access, Microsoft, regression, regression analysis, linear regression, statistics, VBA, VB, Visual Basic, coefficients, r squared, standard error

Views: 8189Comments: 13

"Domain Aggregate" for Concatenating Values by Group in Microsoft Access

matthewspatrick02/02/2010, 12:00 AM

by Patrick G. Matthews A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for each distinct value in ColumnA from a particular table or query.  For example

Topic: Microsoft Access DatabaseTags: Access, VBA, SQL, query, domain aggregate, concatenate

Views: 7941Comments: 21

Analytical SQL : Where do you rank?

mwvisa109/16/2009, 12:00 AM

"Top 10 customers by salesperson" sound familiar?  Yes!  I would expect so, and am sure there are a number of other great business analyses with a similar principle now flowing through your mind. So, how do you query this data in your SQL system?

Topic: SQL Query SyntaxTags: Analytical Functions, Row_Number, Rank, NTile, Dense_Rank, Over, MySQL, Oracle, MS SQL, MS Access

Views: 6882Comments: 27

Covariance and Correlation in MS Access

matthewspatrick03/24/2010, 12:00 AM

by Patrick G. Matthews Introduction Access provides functions for computing several common descriptive aggregate statistics for column data, offering such aggregate functions as Count, Sum, Min, Max, standard deviation and variance (StDev,

Topic: Microsoft Access DatabaseTags: correlation, correlated, covariance, MS, Microsoft, Access, domain aggregate, Visual Basic, Visual Basic for Applications, VB, VBA

Views: 6419Comments: 23

Dlookup and the Domain Functions

JDettman06/18/2008, 12:00 AM

 Applies to: All versions of Access   Skill Level:Beginner   One of the common questions we see in the Access zone is how to get a value from a table.  One way to do that is with a set of built-in functions called Domain functions.  These functio

Topic: Microsoft Access DatabaseTags: "Microsoft Access" Access VBA Beginner

Views: 6183Comments: 17
Loading Advertisement...

Top MS Access Experts

  1. mbizup

    784,072

    Sage

    4,520 points yesterday

    Profile
    Rank: Genius

  2. capricorn1

    766,094

    Sage

    10,500 points yesterday

    Profile
    Rank: Savant

  3. boag2000

    656,789

    Sage

    6,500 points yesterday

    Profile
    Rank: Genius

  4. LSMConsulting

    447,337

    Wizard

    1,000 points yesterday

    Profile
    Rank: Savant

  5. fyed

    441,791

    Wizard

    1,510 points yesterday

    Profile
    Rank: Genius

  6. DatabaseMX

    341,349

    Wizard

    1,500 points yesterday

    Profile
    Rank: Savant

  7. JDettman

    274,883

    Guru

    2,510 points yesterday

    Profile
    Rank: Genius

  8. peter57r

    259,954

    Guru

    0 points yesterday

    Profile
    Rank: Savant

  9. als315

    222,728

    Guru

    6,000 points yesterday

    Profile
    Rank: Genius

  10. matthewspatrick

    157,448

    Guru

    3,610 points yesterday

    Profile
    Rank: Savant

  11. Helen_Feddema

    125,149

    Master

    0 points yesterday

    Profile
    Rank: Genius

  12. imnorie

    118,132

    Master

    600 points yesterday

    Profile
    Rank: Genius

  13. danishani

    106,613

    Master

    0 points yesterday

    Profile
    Rank: Wizard

  14. cactus_data

    85,952

    Master

    1,200 points yesterday

    Profile
    Rank: Genius

  15. TheHiTechCoach

    80,124

    Master

    0 points yesterday

    Profile
    Rank: Sage

  16. dqmq

    77,066

    Master

    1,500 points yesterday

    Profile
    Rank: Genius

  17. harfang

    74,385

    Master

    50 points yesterday

    Profile
    Rank: Genius

  18. Nick67

    59,053

    Master

    0 points yesterday

    Profile
    Rank: Sage

  19. Sudonim

    49,486

    0 points yesterday

    Profile
    Rank: Wizard

  20. pteranodon72

    45,520

    2,000 points yesterday

    Profile
    Rank: Wizard

  21. aikimark

    43,748

    2,000 points yesterday

    Profile
    Rank: Genius

  22. IrogSinta

    37,564

    1,500 points yesterday

    Profile

  23. TechMommy

    35,330

    70 points yesterday

    Profile
    Rank: Master

  24. BillDenver

    31,954

    0 points yesterday

    Profile
    Rank: Guru

  25. hnasr

    31,316

    0 points yesterday

    Profile
    Rank: Genius

Hall Of Fame