MS Query: Can't use parameters and totals simultaneously

C

Chule Walker

In MS Query, I can set up a query with parameters (and
pass them from Excel) and I can also use the totals
function (Max) to retrieve the record with the latest
date, but I cannot do both at the same time. This in not
an issue in MS Access where you set up your parameter
prompts and then add the totals row but there is no totals
row in MS Query, only a button to Cycle Through Totals
once you select the desired column. When I try to do
both, I get the following Message:

Invalid column name 'Enter LotCode'.
Invalid column name 'Enter ActionCode'.
Invalid column name 'Enter StepCode'.
Statement(s) could not be prepared.

Any help will be appreciated!

Chule Walker
[email protected]
 
Top