<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>Hi all (A2K)</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>This line of code works:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2> strsql = "INSERT
INTO tblItemsInQuote (quoteID, Sequence) VALUES (" & IntQuoteID & ","
& StrDayNo & ")"<BR>The debug shows result as:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>INSERT INTO tblItemsInQuote (quoteID,
Sequence) VALUES (1,1)</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2> </DIV></FONT>
<DIV><FONT face=Arial color=#0000ff size=2>But I cannot get it right when I
amend it to also populate a date field, ie using:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>strsql = "INSERT INTO tblItemsInQuote
(quoteID, Date, Sequence) VALUES (" & IntQuoteID & ",#" & DteDay1
& "#," & StrDayNo & ")"</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>The debug shows it as:</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>INSERT INTO tblItemsInQuote (quoteID,
Date, Sequence) VALUES (1,#01/04/03#,1)</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>TIA</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath Pelletti<BR>Software Design
& Solutions Pty Ltd.<BR>Ph: 9505-6714<BR>Fax: 9505-6430<BR><A
href="mailto:SDSSoftware@Optusnet.com.au">SDSSoftware@Optusnet.com.au</A></FONT></DIV></BODY></HTML>