Updating using Function

[hongbin81]

I have a function that I made in Modules called modFunc...

fGetCost([Date],[Time],[Duration])

This function results in indicating a Cost according to Date, Time and Duration.

I need to update ALL RECORDS using this function.

Is there a way of applying this function using update query to update all records in my table?

I tried using this
UPDATE YourTable
SET FieldYouWantToUpdate=fGetCost([Date],[Time],[Duration]);

But it didn't work and this is driving me nuts.
What am I doing wrong?

 

[hongbin81]

It only updates one record...ahhh~!