Forever Enter Parameter Values

[c.yyang]

I cant get rid of this,
some people say there is something wrong with the field, so i checked but there is no prob(i assume)
can you guys take a look on it for me?

open final amount query and the report


I will be grateful if you guys could take a look at this


Database12.zip

[rzw0wr]

SELECT DISTINCTROW [Customer Order Query].Order_ID, [Customer Order Query].Date, [Customer Order Query].Customer_ID, [Customer Order Query].Status, Sum([Customer Order Query].Line_total) AS Total, IIf([Total]>50,"yes","no") AS Discount, IIf([Discount]="yes",[Total]*0.9,[Total]) AS [Amount to Pay]
FROM [Customer Order Query]
GROUP BY [Customer Order Query].Order_ID, [Customer Order Query].Date, [Customer Order Query].Customer_ID, [Customer Order Query].Status;

Change Discount and Amount to pay from Group By to Expression.


Dale

[c.yyang]

Thanks so much for your reply
works like a charm