Hi all,
I've got a query which selects the highest number within a column, but what I am trying to do is add 1 onto it -can anyone tell me if this is possible within the QBE? Or even within an SQL statement?
Thanks
Hi all,
I've got a query which selects the highest number within a column, but what I am trying to do is add 1 onto it -can anyone tell me if this is possible within the QBE? Or even within an SQL statement?
Thanks
Hi,
Your thread appears as solved.
Can I request sharing the solution for other users benefit.
Thanks
Sorry... I didnt use the query builder in the end I used dmax and then added 1 on the end
Code:Me![PO No] = DMax("val([No])", "Purchase No") + 1
Thanks for sharing.
I was thinking somewhere along the lines of
SELECT Max(Table1.testNumber)+1 AS MaxOftestNumber
FROM Table1;
Once again Thanks for Sharing.