Thanks Imar!!!!

Enzo

-----Original Message-----
From: Imar Spaanjaars [mailto:Imar@S...]
Sent: Saturday, September 21, 2002 4:39 PM
To: sql language
Subject: [sql_language] Re: Multiple Append Query


Hi Enzo,

Yes you can. Simply drop the VALUES statement and their parentheses. Also, 
you'll need to change the location of the number:

      INSERT INTO tblBooklet (BookletNo,BxFrom) SELECT 
Max(BookletNo)+1,1000 FROM tblBooklet


HtH

Imar



At 12:31 PM 9/21/2002 +0800, you wrote:


>I understand that in multiple append queries the format is like this:
>--> INSERT INTO tblBooklet (BookletNo) SELECT Max(BookletNo)+1 FROM tblBooklet
>
>But is it possible to have like this:
>--> INSERT INTO tblBooklet (BookletNo,BxFrom) VALUES (SELECT 
>Max(BookletNo)+1 FROM tblBooklet,1000)
>
>Thanks,
>
>Enzo