Changing a data type (1 Viewer)

[aziz rasul]

I have a make-table grouped query. One of the fields called [TotalDue] has Expression in the Totals: row. When the table is created the [TotalDue] field is TEXT. How can I change it to a NUMERICAL data type using VBA?

 

[Mile-O]

CInt()      - convert to integer
CDbl()      - convert to double
CSng()      - convert to single
CLng()      - convert to long
CDate()      - convert to date
CBool()      - covert to boolean
CCurr()      - convert to currency
CStr()      - convert to string
CDec()      - covert to decimal
CByte()      - convert to byte
CVar()      - convert to variant

 

[aziz rasul]

Thanks Miles. Appreciate it. I should have thought of it myself. But I'm thick.

 

[akt01]

I'm even thicker. I don't understand. Is this the code you would put in the make-table query:

Expr1: CDate([TextDate])

When I try to run the query I get a compile error

Help?