Question by  Eia (24)

What is the process for counting and grouping data with access?

I need to count and group data with access.


Answer by  redwings1907 (81)

I'm not sure exactly what you mean by "counting" the date. In terms of grouping the data in Access, the easiest method I have found is to filter each column. By filtering the data you are able to manipulate the data into displaying the information that you need to see.


Answer by  gigo (1706)

Over the object DoCmd you can execute with RunSQL every SQL query. With that you make a "group by" or a "count". For example you can write "SELECT a, b, c FROM mytable WHERE... Group by... " Or you can write for counting "SELECT a, (COUNT b), c AS mycounts FROM mytable GROUP BY... ".


Answer by  Munawer (365)

Rows can be counted by "Count(column_name)" and grouping can be done by "group by column_name" function. When grouping the column name must also be in the "select" statement.


Answer by  pandaoei (5)

The query in access can do the counting and grouping data. You can count data by query using COUNT() , and group data using GROUP BY


Answer by  belindagold (39)

Access 2007, go to the Create ribbon, select Simple Query Wizard, Add the applicable fields to the query, Choose Next, Select SUMMARY, then select summary options. This will display the fields that are eligible for count, sum, average, and Max. In the lower right hand corner, there is also a "count" function.


Answer by  laura27 (1216)

you can use microsoft word processor on your computer to count and regroup data to keep up with important tasks and be organized. This will help so you can go right to it to complete assigned work more in a quicker manner. It helps stay organized without clutter.


Answer by  vijayparttimejob (2254)

First of all, we have a database for all company customer cases. Every case has its own priority level. HigH, Medium, and Low. we are trying group all the case


Answer by  Rani60 (351)

Counting is the process of total number of data. Grouping is the process of group the data. Each group has many number of data.

You have 50 words left!