Update problem

[peljo]

In my update line of my query i get the eror called undefined function.What may be the reason ? My line is :
[products].[exworks]+[offset].Nz([PackTax];0)

 

[HarleyQuinn]

Wrap the whole of your [offset].[PackTax] in the Nz function. e.g.

Nz([offset].[PackTax],0)

Also (as I've done) use a comma rather than a semi-colon in your Nz function.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.