Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Looking at your sample and table and reading your question about what seems to be a thousand times, I may understand what you want. In order to get the needed sequence, I concatenated Date, Program and Ensemble using the following SQL as a Query:

SELECT "DATE" || ' ' || "PROGRAM" || ' ' || "ENSEMBLE" "MUSICGROUPING", "COMPOSER", "TITLE", "MASTERWORK", "ENSEMBLE", "PROGRAM", "DATE", "CATEGORY", "ORDER" FROM "MUSICLIST" "MUSICLIST" ORDER BY "CATEGORY", "DATE", "PROGRAM", "ORDER"

The field names are the same just all upper case (has it's benefits).

For the report I used two levels of grouping - First "CATEGORY" and second "MUSICGROUPING" ( the concatenated field). Sort on CATEGORY then MUSICGROUPING then ORDER. That produces this report:

image description

It's a bit crude but gives the results (used some of you data but just in relevant parts). Also changed one record date which produced this report:

image description

This shows grouping with same dates is in correct sequence. All the dressing up and formatting is up to how you want it to appear.

Hope I interpreted your question correctly.

Looking at your sample and table and reading your question about what seems to be a thousand times, I may understand what you want. In order to get the needed sequence, I concatenated Date, Program and Ensemble using the following SQL as a Query:

SELECT "DATE" || ' ' || "PROGRAM" || ' ' || "ENSEMBLE" "MUSICGROUPING", "COMPOSER", "TITLE", "MASTERWORK", "ENSEMBLE", "PROGRAM", "DATE", "CATEGORY", "ORDER" FROM "MUSICLIST" "MUSICLIST" ORDER BY "CATEGORY", "DATE", "PROGRAM", "ORDER"

The field names are the same just all upper case (has it's benefits).

For the report I used two levels of grouping - First "CATEGORY" and second "MUSICGROUPING" ( the concatenated field). Sort on CATEGORY then MUSICGROUPING then ORDER. That produces this report:

image description

It's a bit crude but gives the results (used some of you data but just in relevant parts). Also changed one record date which produced this report:

image description

This shows grouping with same dates is in correct sequence. All the dressing up and formatting is up to how you want it to appear.

Hope I interpreted your question correctly.

Edit 11/06/16 Add Sample - MusicListReports.odb

There are three reports in sample: 1 = first one shown in this answer; 2 = second one shown; 3 = same report as first without the ORDER field displayed.

Looking at your sample and table and reading your question about what seems to be a thousand times, I may understand what you want. In order to get the needed sequence, I concatenated Date, Program and Ensemble using the following SQL as a Query:

SELECT "DATE" || ' ' || "PROGRAM" || ' ' || "ENSEMBLE" "MUSICGROUPING", "COMPOSER", "TITLE", "MASTERWORK", "ENSEMBLE", "PROGRAM", "DATE", "CATEGORY", "ORDER" FROM "MUSICLIST" "MUSICLIST" ORDER BY "CATEGORY", "DATE", "PROGRAM", "ORDER"

The field names are the same just all upper case (has it's benefits).

For the report I used two levels of grouping - First "CATEGORY" and second "MUSICGROUPING" ( the concatenated field). Sort on CATEGORY then MUSICGROUPING then ORDER. That produces this report:

image description

It's a bit crude but gives the results (used some of you data but just in relevant parts). Also changed one record date which produced this report:

image description

This shows grouping with same dates is in correct sequence. All the dressing up and formatting is up to how you want it to appear.

Hope I interpreted your question correctly.

Edit 11/06/16 Add Sample - MusicListReports.odbMusicListReports2.odb

There are three reports in sample: 1 = first one shown in this answer; 2 = second one shown; 3 = same report as first without the ORDER field displayed.

Looking at your sample and table and reading your question about what seems to be a thousand times, I may understand what you want. In order to get the needed sequence, I concatenated Date, Program and Ensemble using the following SQL as a Query:

SELECT "DATE" || ' ' || "PROGRAM" || ' ' || "ENSEMBLE" "MUSICGROUPING", "COMPOSER", "TITLE", "MASTERWORK", "ENSEMBLE", "PROGRAM", "DATE", "CATEGORY", "ORDER" FROM "MUSICLIST" "MUSICLIST" ORDER BY "CATEGORY", "DATE", "PROGRAM", "ORDER"

The field names are the same just all upper case (has it's benefits).

For the report I used two levels of grouping - First "CATEGORY" and second "MUSICGROUPING" ( the concatenated field). Sort on CATEGORY then MUSICGROUPING then ORDER. That produces this report:

image description

It's a bit crude but gives the results (used some of you data but just in relevant parts). Also changed one record date which produced this report:

image description

This shows grouping with same dates is in correct sequence. All the dressing up and formatting is up to how you want it to appear.

Hope I interpreted your question correctly.

Edit 11/06/16 Add Sample - MusicListReports2.odbMusicListReports3.odb

There are three reports in sample: 1 = first one shown in this answer; 2 = second one shown; 3 = same report as first without the ORDER field displayed.

Looking at your sample and table and reading your question about what seems to be a thousand times, I may understand what you want. In order to get the needed sequence, I concatenated Date, Program and Ensemble using the following SQL as a Query:

SELECT "DATE" || ' ' || "PROGRAM" || ' ' || "ENSEMBLE" "MUSICGROUPING", "COMPOSER", "TITLE", "MASTERWORK", "ENSEMBLE", "PROGRAM", "DATE", "CATEGORY", "ORDER" FROM "MUSICLIST" "MUSICLIST" ORDER BY "CATEGORY", "DATE", "PROGRAM", "ORDER"

The field names are the same just all upper case (has it's benefits).

For the report I used two levels of grouping - First "CATEGORY" and second "MUSICGROUPING" ( the concatenated field). Sort on CATEGORY then MUSICGROUPING then ORDER. That produces this report:

image description

It's a bit crude but gives the results (used some of you data but just in relevant parts). Also changed one record date which produced this report:

image description

This shows grouping with same dates is in correct sequence. All the dressing up and formatting is up to how you want it to appear.

Hope I interpreted your question correctly.

Edit 11/06/16 Add Sample - MusicListReports3.odbMusicListReports4.odb

There are three reports in sample: 1 = first one shown in this answer; 2 = second one shown; 3 = same report as first without the ORDER field displayed.