Advertisement

05.06.2008 at 08:51AM PDT, ID: 23379875
[x]
Attachment Details

MS Access 2003 SQL I have 100 records in one field and several different records within that field.

Asked by deer3777 in Databases Miscellaneous, Microsoft Access Database, SQL Query Syntax

MS Access 2003 SQL I have 100 records in one field and several different types of data within that field.  I need a count on each individual type of data within that field.  When I say type, I mean that the data differs not the data type.  So I need to get a count of occurences of John, Nancy, Greg within this field.  How would I do this with SQL?Start Free Trial
[+][-]05.06.2008 at 09:02AM PDT, ID: 21508440

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Databases Miscellaneous, Microsoft Access Database, SQL Query Syntax
Sign Up Now!
Solution Provided By: omgang
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.06.2008 at 09:03AM PDT, ID: 21508450

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.06.2008 at 11:07AM PDT, ID: 21509541

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.06.2008 at 11:12AM PDT, ID: 21509575

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628