Expression not working in query

[Bob Blooms]

Attempting to forescast the values of salary increase for individuals who will receive step increases during the fiscal year. The trigger is a Salary Consideration Date (Sal Con Date). I have been able to calculate the percentage of the year that the indivudal will have the new salary. By problem is getting the next step for their respective job classification (JobClass). I thought I could simply and 1 to their current step which is in the query. No luck, as the screen shot shows!

[orange]

Please describe in more detail.
Show the query SQL.

The error message is pretty clear - at least where to start looking.

[Bob Blooms]

Looked at the query SQL. I think I understand the SELECT statement (had a flash back to my COBOL days) and FROM statement, and the filter WHERE statement. What I cannot do is but the logic together to find the error.

SELECT tblCS3Compilation.Name, tblCS3Compilation.JobClass, tblCS3Compilation.Step, tblSalaryTables.Salary, tblCS3Compilation.[Sal Con Date], DateDiff("d",[Sal Con Date],41455) AS LagTime, [lagtime]/365 AS StepIncreasePeriod, [Step]+1 AS [New Step]
FROM tblCS3Compilation INNER JOIN tblSalaryTables ON (tblCS3Compilation.Step = tblSalaryTables.Step) AND (tblCS3Compilation.JobClass = tblSalaryTables.JobClass)
WHERE (((tblCS3Compilation.[Sal Con Date])<>0));

[Bob Blooms]

I found my error. I needed to add [table.Step]

[orange]

I tried the part of your query I could decpher from the diagram, and using the database I sent you previously, tried the followinr
(it doesn't have all your output fields)

SELECT [CS-3Compilation].Name, [CS-3Compilation].JobClass, [CS-3Compilation].Step, SalaryForJobClassLevels.Salary, [CS-3Compilation].[Sal Con Date], (select JobLevel +1 as NextStep from SalaryForJobClassLevels   NX  where JobClass =SalaryForJobClassLevels.JobClass and JobLevel =SalaryForJobClassLevels.JobLevel) AS Expr1
FROM [CS-3Compilation] INNER JOIN SalaryForJobClassLevels ON ([CS-3Compilation].Step = SalaryForJobClassLevels.JobLevel) AND ([CS-3Compilation].JobClass = SalaryForJobClassLevels.JobClass)
WHERE ((([CS-3Compilation].[Sal Con Date])<>0));