Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wavesurf
-
INSERT INTO ... VALUES Drops leading zero
Of course. I must be left-brained today. Thanks for your help!- wavesurf
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
INSERT INTO ... VALUES Drops leading zero
The leading zero is dropped during this append query Table named Calc exists with Text fields: Serial and Julian. The Code: Dim strJulain as string strJulian = Right(year(date), 1) & DatePart("y", date()) DoCmd.RunSQL "INSERT INTO Calc(Serial, Julian) VALUES(tboSerial, " & strJulian & ")" I...- wavesurf
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
