If functions in Access 2007

Hi James

Sorry for the delay in responding.

You cannot create any calculated fields or use functions directly into a table.

You need to create a query do the relavant calculations in it and if needed you can append the results back to the table or use the Make-Table query and create a new table

Hope this helps

Carlos