Select Query Not Updateable with Sort Order

[sxschech]

I have a data table and a table that defines sort orders depending on whether data for input or for reporting. I have a form that I use to input data, but I need to change some values and in order to put in the correct values, I need to use the table that defines the input sort order so that I can correctly read the data off the hard copy. Any thoughts on how I can do this, or do I need to copy to a temp table fix data, delete existing data and append? Item in red is what I'm pulling from the sort table to change the order that records are displayed in order to match the hard copy. Here is the query:
[tt]
SELECT tblApplicants.SType, tblApplicants.Yr, tblApplicants.Semester, tblApplicants.Report_Date, tblApplicants.WeekNo, tblApplicants.School, tblApplicants.Major, tblApplicants.App_Status, tblApplicants.App_Count
FROM tblAppStatus INNER JOIN tblApplicants ON tblAppStatus.AppStatus = tblApplicants.App_Status
WHERE tblApplicants.SType="F" AND tblApplicants.Yr="2006" AND tblApplicants.Report_Date=#3/3/2006#
ORDER BY tblApplicants.Semester, tblApplicants.School, tblApplicants.Major, [red]tblAppStatus.AppStatus_UGradeSort[/red];
[/tt]

AppStatus and AppStatus_Sort are defined as the primary key in the tblAppStatus Table.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886