Jump to content

What is ordinary way to do grouping records?


This topic is 2577 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Assuming there are fields such as FirstName, Age, and State.

Here's all the records in a table

6 records all

John 19 CA

Andy 27 TX

John 34 NY

Jake 21 WA

John 19 OR

Andy 17 TX

If I want to group them by FirstName and Age, I would make a calculation field that is 'FirstName & Age' as text.

Then make this as unique key then I'd try to create records to other table so that I can make these grouped by combination of 2 fields.

But it takes just a bit time to do so because I have to run script of Loop and set field.

As the larger number of records, it tales longer....

Is there any way to make these records grouped real quick just like MS Access's grouping?

Do I always need to make another table and calculate field to make unique key?

Is there any other easy way to acomplish?

I could go with sub-summary view but it actually won't decrease records. It just show visually grouped. The number of records is still the same. I want actual shrinked records by grouping.

How can I?Do O always need to create new records to other table via relationship? I want them to be like this

5 records all

John 19

Andy 27

John 34

Jake 21

Andy 17

I want to acomplish something like this if I'm doing with MS Access.

1st query . gropued by FirstName and Age

2nd query . grouped by FirstName and State

3rd query . Left Join 1st query.FirstName=2nd query.FirstName

Link to comment
Share on other sites

I could go with sub-summary view but it actually won't decrease records. It just show visually grouped. The number of records is still the same. I want actual shrinked records by grouping.

 

 

Can you explain why would you want to do that? Creating new records in another table is definitely not "the ordinary way" to group existing records. Not even in MS Access, I hazard a guess.

Link to comment
Share on other sites

I don' know how to...

 

The same way you started, only simpler:

 

1. Find the records you want to summarize;

 

2. Sort them by FirstName and by Age;

 

3. Show them in a list layout that contains a sub-summary part (when sorted by Age) and no body part.

 

 

The result will look something like this:

post-72594-0-71783600-1405033271_thumb.p

Link to comment
Share on other sites

The same way you started, only simpler:

1. Find the records you want to summarize;

2. Sort them by FirstName and by Age;

3. Show them in a list layout that contains a sub-summary part (when sorted by Age) and no body part.

The result will look something like this:

rep.png

Thanks for the help! That's the point!

Even if you did it, the number of records is 6 not 5...

What if I want to use next sub-summary out of these decreased 5 records after 1st sub-summary?

Do I need to make new table?

Link to comment
Share on other sites

Thanks for the help! That's the point!

Even if you did it, the number of records is 6 not 5...

 

Why is that a problem?

 

Note that this question is about grouping records; if you group 6 records into 5 groups, you still have 6 records.

 

 

What if I want to use next sub-summary out of these decreased 5 records after 1st sub-summary?

 

I am afraid I don't understand this part.

Link to comment
Share on other sites

This topic is 2577 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.