Group by numbering (A.B.C)

[arctushar]

Hello
I have a database and in that there is a field containing numbers eg. 1 1.1 1.2 1.3 1.3.1 1.3.2 etc. No I want to make a report what will automatically group by this number system . Is it possible?

If possible then plz help me.

 

[Mr. B]

Set Sorting and Grouping for the report to the field you want the report sorted and grouped on.

 

[arctushar]

Actually I want that
subnumber will be automatically group by the main number. not by sorting. only by grouping

 

[Mr. B]

You will need to isolate the value that you want to use for Grouping. You can do this in a query by using the Left(), Mid(), InStr(), or Right() functions or a combination of these functions. You would need to create a new column, name it as you desire and then use the functions mentioned above to isolate the derired value. Once you have the value isolated you can ust that query as the recordset for your report and set the column that isolated the desired value as the column to group the report on.

You do not have to specify sorting to use the Sorting and Grouping feature of your report.