Search results
-
T
Make Query - Defining fields
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... -
T
Update a field with no value
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... -
T
VBA and SQL
: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...- Torsan
- Thread
- Replies: 1
- Forum: Modules & VBA
-
T
Define number of digits in table fields
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...