Code works in debug but can't publish

[access101]

not sure whats wrong with this

SELECT Projection.[Day], SUM(datediff('n', Sched.Start, Sched.[End]) / 60) AS Hours, AVG(SalaryRate.Expr3) + SUM(Staff.Rate1 * (datediff('n', Sched.Start, Sched.[End])
/ 60)) AS Wage, wage / AVG(Projection.AvgOfPm) * 100 AS Expr1, weekday(Projection.ID, 4) AS WK, Projection.AvgOfAm, Sched.Shift
FROM (((Sched INNER JOIN
Projection ON Sched.[Day] = Projection.[Day]) INNER JOIN
SalaryRate ON Sched.[Day] = SalaryRate.[Day]) INNER JOIN
Staff ON Sched.Employee = Staff.Employee)
WHERE (Sched.Shift = 'Am')
GROUP BY Projection.[Day], weekday(Projection.ID, 4), Projection.AvgOfAm, Sched.Shift
ORDER BY weekday(Projection.ID, 4)

when testing eveything works just fine but when i publish and run the application it says

System.Data.OleDb.OleDbException (0x80040E10): No value given for one or more required parameters.

 

[jebenson]

Do you get this error on the development machine (i.e., running the exe, not in the dev env), or is this on another machine?

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!