enter parameter value dialog box

[exupery]

Hello, if I open a query, wild parameter value boxes (4) appears and I dont want them. I know, where is the problem, but reason is secret for me.

SQL:
SELECT Year([sdd]) AS [Year], Month([sdd]) AS [Month], tab_sqm_data_my_supplier.[Reporting unit], tab_sqm_data_my_supplier.Plant, tab_sqm_data_my_supplier.[Supplier code], tab_sqm_data_my_supplier.[Supplier name], Sum(tab_sqm_data_my_supplier.[Sum of exp# qty]) AS [SumOfSum of exp# qty], Sum(tab_sqm_data_my_supplier.Penalty) AS SumOfPenalty, Avg(tab_sqm_data_my_supplier.[Overdue days]) AS [AvgOfOverdue days], Sum(tab_sqm_data_my_supplier.[Overdue qty]) AS [SumOfOverdue qty], IIf([COT]<[COT Alarm],"Alarm",IIf(([COT]>=[COT Alarm]) And ([COT]<[COT target]),"OK","TargetOK")) AS [COT status], tab_supplier_db.[COT Alarm], tab_supplier_db.[COT target], tab_supplier_db.Measured, tab_sqm_data_my_supplier.[COT formula], Avg(tab_sqm_data_my_supplier.[COT (%)]) AS [AvgOfCOT (%)], IIf([COT formula]="type1",[avgofCOT (%)],(1-([SumOfOverdue qty]/[SumOfSum of exp# qty]))*100) AS COT
FROM tab_supplier_db INNER JOIN tab_sqm_data_my_supplier ON tab_supplier_db.[Supplier_name] = tab_sqm_data_my_supplier.[Supplier name]
GROUP BY Year([sdd]), Month([sdd]), tab_sqm_data_my_supplier.[Reporting unit], tab_sqm_data_my_supplier.Plant, tab_sqm_data_my_supplier.[Supplier code], tab_sqm_data_my_supplier.[Supplier name], IIf([COT]<[COT Alarm],"Alarm",IIf(([COT]>=[COT Alarm]) And ([COT]<[COT target]),"OK","TargetOK")), tab_supplier_db.[COT Alarm], tab_supplier_db.[COT target], tab_supplier_db.Measured, tab_sqm_data_my_supplier.[COT formula], IIf([COT formula]="type1",[AvgOfCOT (%)],(1-([SumOfOverdue qty]/[SumOfSum of exp# qty]))*100)
HAVING (((tab_sqm_data_my_supplier.[COT formula])>"0"))
ORDER BY Year([sdd]) DESC , Month([sdd]) DESC , tab_sqm_data_my_supplier.[Supplier name];



bold values are parameter values and I know, if I use they in the same SQL like this, they will appears.

So the question is, how to change this code with no PV reason.

At the end, sorry for my english.

[ranman256]

You get params asked if:
a field does not exist in the table,
A field you think exists, but is misspelled.

You cannot use a field you created in the query in an expression in the same query....
Sum(field), 1-(SumOfField) as new field

Note: Dont put spaces in Field labels. It could introduce problems.

[June7]

Build a report and do those secondary calcs in textboxes.

Also advise not to use punctuation and special characters (underscore only exception) in names.

[pbaldy]

.
You cannot use a field you created in the query in an expression in the same query....
Sum(field), 1-(SumOfField) as new field.

Well, sometimes you can. Typically the problem arises when you try to use an aliased field in the WHERE or GROUP BY clause, due to the order in which clauses are evaluated.