something like this I was hoping
SELECT MAX([database.[ID]) AS [LAST-DEFECT] FROM [database]
> Hi.
>
> I have a database where information is submitted to.
> On the submit page I want to show the ID number of next 'thing' to be
> submitted.
> I use auto increment for the ID.
> There must be som
Hi.
I have a database where information is submitted to.
On the submit page I want to show the ID number of next 'thing' to be
submitted.
I use auto increment for the ID.
There must be some way of asking what the last ID number was (I can then add
one to this)
is there a function for this? or do