help in compile error

[cliff]

Hi, when I run the following query , I get the following error :
compile error. in query question 'nz(dmax("iteration","tbl_rndnumstore"),0)+1'


INSERT INTO tbl_RndNumStore ( Iteration, numvalue, ruleid )
SELECT NZ(DMax("Iteration","tbl_RndNumStore"),0)+1 AS Expr1,
tbl_RndNum1.numvalue, tbl_rndnum1.ruleid
FROM tbl_RndNum1;


Please help to solve it

thanks

cliff

 

[Bob Barrows]

Hi, when I run the following query , I get the following error :
compile error. in query question
'nz(dmax("iteration","tbl_rndnumstore"),0)+1'


INSERT INTO tbl_RndNumStore ( Iteration, numvalue, ruleid )
SELECT NZ(DMax("Iteration","tbl_RndNumStore"),0)+1 AS Expr1,
tbl_RndNum1.numvalue, tbl_rndnum1.ruleid
FROM tbl_RndNum1;

Are you running this via ADO? From an external application? If so, Nz is an
Access-defined function that is not available to external applications. You
will need to replace it with iif.