Search results

Thank you. Again MS Access proves that MS Fox Pro is way better.

When I run this query, the fields in the new table contains 253 characters. How do I specify in the SQL command that the field Carg2 and Carg3 will contain 3 charachters ? SELECT dbo_allesc.AccReport, Left([AccReport],2) AS Carg2, Left([AccReport],3) AS Carg3,......................... INTO...

Thanks That did it!! Thanks..

IsNull is not doing it. The IsNull does not work, which I find hard to understand. Again, the field is empty and need a "zero"

How do I update an cell with no value (not even zero) to have a zero? In fox pro I used ISBLANK, but I can't find a similar function. I tried this one: IsMissing([Volume]![Omsetning]) But it only finds the zeros. Note, the field is numeric. I need this to work, since the average of the field...

:eek: I've been working with Visual Fox Pro, but I now have to convert to Access. I hope somebody can help me to get introduced of how to write a simple SQL in VBA. My book sucks I I can't make the connection work. For testing purposes I need to know how to create a table based upon another...

I'm just to work with Fox Pro, and I am therefore puzzled with how to define the exact number of digits in a field in a table in Access. If I need 9 digits + 2 decimals in a number filed, how do I define that in design view? Also, I need to know how to export a table into a text file, with a...