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

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.

Thanks for a comment.

If I could do grouping within the same table.

That's the best but I don' know how to...

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:

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?

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.