<!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>....that's it. Much
appreciated.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=chris@denverdb.com href="mailto:chris@denverdb.com">Chris Mackin</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, April 09, 2003 1:35
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] HELP - Date in SQL
string</DIV>
<DIV><BR></DIV>Try renaming the [Date] field to anything that's NOT a reserve
keyword. A<BR>field name should never be one of the Access reserved
keywords<BR>(here's a list:<BR><A
href="http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q209187">http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q209187</A>)<BR><BR>Change
the name of the field "Date" to "MyDateField" or whatever and try
it<BR>again.<BR><BR>Chris Mackin<BR><A
href="http://www.denverdb.com">www.denverdb.com</A><BR>Denver Database
Consulting, LLC<BR><BR>-----Original Message-----<BR>From: <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A><BR>[mailto:accessd-bounces@databaseadvisors.com]On
Behalf Of Software Design &<BR>Solutions Pty Ltd.<BR>Sent: Tuesday, April
08, 2003 9:19 PM<BR>To: <A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR>Subject:
[AccessD] HELP - Date in SQL string<BR><BR><BR>Hi all (A2K)<BR><BR>This line
of code works:<BR> strsql = "INSERT INTO tblItemsInQuote
(quoteID, Sequence) VALUES (" &<BR>IntQuoteID & "," & StrDayNo
& ")"<BR>The debug shows result as:<BR>INSERT INTO tblItemsInQuote
(quoteID, Sequence) VALUES (1,1)<BR><BR>But I cannot get it right when I amend
it to also populate a date field, ie<BR>using:<BR>strsql = "INSERT INTO
tblItemsInQuote (quoteID, Date, Sequence) VALUES (" &<BR>IntQuoteID &
",#" & DteDay1 & "#," & StrDayNo & ")"<BR><BR>The debug shows
it as:<BR>INSERT INTO tblItemsInQuote (quoteID, Date, Sequence)
VALUES<BR>(1,#01/04/03#,1)<BR><BR>TIA<BR><BR>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><BR><BR><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>