Converting a Text field to a number in a table

[Payal Patel]

Hi,
I have imported data from a csv file. One of the fields coming in is in a time / text format. Once I bring the data into the table, is there a query i can run to convert the text field to a number?

thanks,
P

 

[raskew]

Hi -

Consider the TimeValue() function. Here are examples from the debug (immediate) window:

x = "12:56:37 PM" 
y = timevalue(x)
? y 
12:56:37 PM 

To show that Access is storing this as a date/time and not a string
? cdbl(y)
 0.53931712962963

HTH - Bob

 

[Payal Patel]

thanks this helped