The following query works fine :

SELECT [Base Data].[Scale Max] AS Old, [Base Data].[New Scale Max FTE] AS
New, [New]-[Old] AS Diff
FROM [Base Data];

However, if I add a descending sort to the last column and then run the
query, I get a window opening asking me to "Enter a Parameter Value" for
New.

Can, SKS give me an idea as to how to resolve the problem.

The query that causes the parameter box to open is below

Tx in advance


Rob

SELECT [Base Data].[Scale Max] AS Old, [Base Data].[New Scale Max FTE] AS
New, [New]-[Old] AS Diff
FROM [Base Data]
ORDER BY [New]-[Old] DESC;