I have a series of reports based on queries in a database that accepts data input via a web form. The queries were designed with ascending sorts on selected fields.
SELECT tblRegistrations.ProjectNo, tblWorkshops.WkshpName, tblRegistrations.LastName, tblRegistrations.FirstName, tblRegistrations.Position, tblRegistrations.District, tblRegistrations.AmtPaid, tblRegistrations.PayType, tblRegistrations.PONumber, tblRegistrations.DateRegist
FROM tblWorkshops LEFT JOIN tblRegistrations ON tblWorkshops.ProjectNumber = tblRegistrations.ProjectNo
WHERE (((tblRegistrations.ProjectNo)=[Type Project #]))
ORDER BY tblRegistrations.LastName, tblRegistrations.FirstName;
The sort/grouping dialogue box (in the report design view) also shows these selected fields sorted ascending BUT, the report does not preview with the selected fields sorted accordingly. I have reapplied the sort by indicating yes for OrderByOn in the properties for the report, but to no avail. Anyone have a thought about what the problem is and a solution could be? Thanks ever so much!
SELECT tblRegistrations.ProjectNo, tblWorkshops.WkshpName, tblRegistrations.LastName, tblRegistrations.FirstName, tblRegistrations.Position, tblRegistrations.District, tblRegistrations.AmtPaid, tblRegistrations.PayType, tblRegistrations.PONumber, tblRegistrations.DateRegist
FROM tblWorkshops LEFT JOIN tblRegistrations ON tblWorkshops.ProjectNumber = tblRegistrations.ProjectNo
WHERE (((tblRegistrations.ProjectNo)=[Type Project #]))
ORDER BY tblRegistrations.LastName, tblRegistrations.FirstName;
The sort/grouping dialogue box (in the report design view) also shows these selected fields sorted ascending BUT, the report does not preview with the selected fields sorted accordingly. I have reapplied the sort by indicating yes for OrderByOn in the properties for the report, but to no avail. Anyone have a thought about what the problem is and a solution could be? Thanks ever so much!