Group by on form

[Andy]

I have a form which is based upon a select query. I have some records which
have a 'Episode ID' which can be the same for some rows and different for
others.

i.e. 3 rows may have their Episode ID equal to '12345', but two other rows
may have this field equal to '56789'.

What I want to do is group each row by their Episode ID, yet still see each
record. Make sense?!

 

[Douglas J. Steele]

Forms don't have the same Group By capabilities as Reports (wherein you can
set a group header that displays the value of the grouping field, with the
details relevant to that particular value displayed underneath the header),
but you can at least sort the data so that all of the rows associated with a
given episode are displayed together.

Create a query with an appropriate ORDER BY clause, and use that query as
the RecordSource for the form, rather than simply using the table as the
RecordSource.

 

[Andy]

Yeah I've already based it upon a select query rather than a table. I could
do what I want in the report, but it would lose the ability for the
'interactive' use of the form of right click filtering etc.