 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / November 2005SQL string
How can I insert into a table value witch is for example 12,3 while it takes it as 2 different values in a sql string (I don't wont the value to converted to string but keep is as double) Thank in advace Show us what you're trying to use now. That will help us see what you're doing and what might need to be changed.  SignatureKen Snell <MS ACCESS MVP> > How can I insert into a table value witch is > for example 12,3 while it takes it as 2 different values in a sql string > (I don't wont the value to converted to string but keep is as double) > > Thank in advace Dim codecustomer, sqlstring As String codecustomer = rslist.Fields("code") sqlstring = " INSERT INTO difference ( custcode, residual, total ) values ('" & codecustomer & "'," & residual & "," & total & ")" DoCmd.RunSQL sqlstring Residual or total might be 12,2 so it takes as 2 values How can I change my sqlstring to bypass the problem? > Show us what you're trying to use now. That will help us see what you're > doing and what might need to be changed. [quoted text clipped - 4 lines] >> >> Thank in advace Enclose the values inside ' characters: sqlstring = " INSERT INTO difference ( custcode, residual, total ) values ('" & codecustomer & "', '" & residual & "', '" & total & "')" SignatureKen Snell <MS ACCESS MVP> > Dim codecustomer, sqlstring As String > codecustomer = rslist.Fields("code") [quoted text clipped - 12 lines] >>> >>> Thank in advace |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.