Q: inserting numbers into db I have to insert numbers into a table using sql statements. However, some of the numbers have digits, and sql interprets these numbers as different fields. I have tried using (,[,",',etc, but nothing works. I also used a trick to format the numbers and changing the comma into a point. This works, except when the numbers are greater then 10000, in which case I get 10.000.000 and an error. Tim Devoldere
A: Function Format Have you looked at the Vb funtion Format. With this function you can format anything to a certain mask. I use it to translate all dates (dd-mm-yy) into db-dates (yyyy-mm-dd). It can also be used to format numbers.. Return