No value given for one or more parameters

[aadebayo]

Hello

I am currently running some code, but I get the above error when it gets to the following SQL statement

SELECT [MEAL-SERVICE-PRICE], [MEAL-TYPE-CODE], [WEEK-ENDING-DATE], [WEEK-ACTUAL-NO], [MEAL-TYPE-NAME], [CLIENT_SCHOOL_MEALS-CC] FROM qrymealsales WHERE [MEAL-TYPE-CODE] = 'M001' AND [CLIENT_SCHOOL_MEALS-CC] = 'EV2202' AND [MEAL-TYPE-NAME] Like '*PUPIL FREE*' AND [MEAL-SERVICE-PRICE] = 1.500 AND week-ending-date = #05/11/2004#

Please can anyone help me.

Ade

 

[Jon K]

Put the last field name in square brackets.

........ AND [week-ending-date] = #05/11/2004#


It's better not to use "-" in field names.
.

 

[aadebayo]

Thanks it worked