help in compile error

  • Thread starter Thread starter cliff
  • Start date Start date
C

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
 
cliff said:
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;
Click to expand...
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.
 
Back
Top