Arranging subform data by date, but grouping names

[Girlywoo]

I am fairly new to Access and have a subform that needs to be ordered.

It has to be arranged it date order (column 1). However if a person (column 2) has completed the task several times, these records need to be grouped together. At the moment I can only organise by 1 column and I'm stuck.

Can anyone help me? Or pass me onto a good website?

Much appreciation. X

[Scott Price]

I am fairly new to Access and have a subform that needs to be ordered.

It has to be arranged it date order (column 1). However if a person (column 2) has completed the task several times, these records need to be grouped together. At the moment I can only organise by 1 column and I'm stuck.

Can anyone help me? Or pass me onto a good website?

Much appreciation. X

Welcome to the Scripts!

In a query (if the subform is based on a table, change it to a query), you can set all the sorting and grouping layers you want. Open the query in design view and you will notice the Sort grid row. Now on the main menu bar of the program window look for a symbol that looks like a sideways capital M. This is the Totals icon, clicking it will bring up another grid row in your query design view. Choose the Group By option for the Person column, and you should be set.

Regards,
Scott

[NeoPa]

... Or pass me onto a good website?
...

Looks like you found yourself a great website already :D
Welcome to theScripts.

[Girlywoo]

Excellent, that helps me so so much. thank you for your help guys.

[Scott Price]

Not a problem, and glad it's working for you!

Regards,
Scott