I have a problem with a Select statement.
I want to select a colom (only a number) from a Table, when I start a form
and add 1 to the number and write the result in a Field on the form.
And than, i want to save it in the same Table and colom!
My select statement is usually like this:
SELECT Max([thenumer])+1 AS numer FROM mytable;
But it dosent woks :(
I cant write VB code. I am looking for a way to solve my problem without
VB code.
Thanks, Amir