I am a beginner to access so be explicit please.
I have a problem tring to create a updatequery using a function that I have written. the function looks like this
public function total (shiftstart as date, shiftend as date) as single
if shiftstart > 0 then
    total = datediff("n", shifstart) - datediff("n", shift end)
elseif shiftstart = 0 then
    total = 0
end if
when i try to use this in an update query I get an error stating that I have an operand or operator error??
Any suggestions would be appreicated

For this: datediff("n", shift end)

there's a space in "shift end" where there shouldn't be. Is that a typo, or is that in your code?

Brian

typo on my part

Your original
is using the wrong syntax for DateDiff.

Try this:

thanks man