My assignment is to print a student's progress report (like a report card).
The parent report has fixed fields of student profile info in the header section.
To "imitate" a 2 column report, the detail section consists of 2 subreports.
SubReport1 is column 1 - shows fall semesters by filtering for ColumnCode = 1
SubReport2 is column 2 - shows spring semesters by filtering for ColumnCode = 2
The parent report's query is a DISTINCT on the fixed fields from TBL_Transcript.
The sub report's query is a does not have a condition in the query for the column code, instead am doing the filter on the column code in the report level.
(Really would like to pass the column code to the query, but i do not know how...
usually i hard code the record source with sql and know how to code sql, but would like to learn how to control
canned queries w/o writing sql.... but i digress)
The problem is, that the query IS SORTING CORRECTLY IN START DATE sequence,
but it's not displaying that way on the report....
uploaded mdb below....
tx for your ideas and advice, sandra