If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Group by on form
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?! |
#2
|
|||
|
|||
Group by on form
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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Andy" wrote in message ... 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?! |
#3
|
|||
|
|||
Group by on form
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. "Douglas J. Steele" wrote: 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Andy" wrote in message ... 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?! |
Thread Tools | |
Display Modes | |
|
|