Time Stamp

[Charles Phillips]

Hello,
Does ANYONE know how to print/insert a "time stamp" in a query???
If you do, point me in the right direction...


Charles L. Phillips

 

[Graham R Seach]

Charles,

SELECT Now() As TimeStamp FROM tblMyTable

INSERT INTO tblMyTable (Field1, Field2) VALUES ("x", Now())

UPDATE tblMyTable SET Field2 = Now()

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Charles Phillips]

"Thank You"...

Charles,

SELECT Now() As TimeStamp FROM tblMyTable

INSERT INTO tblMyTable (Field1, Field2) VALUES ("x", Now())

UPDATE tblMyTable SET Field2 = Now()

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html