R
Rani
What is the best way to express this statment using VB ?
DMax("[ChozeNum]","ChozeTBL")+1
DMax("[ChozeNum]","ChozeTBL")+1
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
Van T. Dinh
What you posted ...
(maybe I didn't understand your question???)
(maybe I didn't understand your question???)
R
Rani
ok , let me rearticulate.
when the value is zero (opening position of the field) the function doesn't
add one to the field and doesn't display field+1 where I want it to.
any idea ?
when the value is zero (opening position of the field) the function doesn't
add one to the field and doesn't display field+1 where I want it to.
any idea ?
Van T. Dinh said:What you posted ...
(maybe I didn't understand your question???)
--
HTH
Van T. Dinh
MVP (Access)
Rani said:What is the best way to express this statment using VB ?
DMax("[ChozeNum]","ChozeTBL")+1
A
Atilla Yildirim
a=nz(DMax("[ChozeNum]","ChozeTBL",""))+1
V
Van T. Dinh
What Atilla posted ...
R
Rani
thanks guys
Atilla Yildirim said:a=nz(DMax("[ChozeNum]","ChozeTBL",""))+1
Rani said:What is the best way to express this statment using VB ?
DMax("[ChozeNum]","ChozeTBL")+1