Hi,
Aleks Kalynovych wrote:
I have a couple forms that generate a unique ID based on taking
the highest
number in the ID column adding 1 to its value. The problem is that I
dont save that number until the form is submitted. If 2 or more
persons fill out
the form at the same time they all
Hi,
I don't think you can do that with MS SQL, it doesn't support TRASFORN, I
think that's strictly Access syntax. MS SQL 7 and up does have ROLLUP etc
but that's part of the OLAP service, which you will only get if you have
Enterprise edition (read $$ :)).
The easiest way to get out of this