Can I type cast in a query? int....?

[pdbowling]

I've got a query that pulls data.

When I have the data, I want to sort it, but the numbers are text.
When I sort text numbers it comes out wrong

110
1123
113
114356
115

Can I type cast this query to make the data retrieved be numeric
(currency)???

SELECT [Prolift].[Fleet#],
nz([prolift].[pTotal]+[ark].[total]) AS total
FROM Ark INNER JOIN Prolift ON [Ark].[Truck#]=[Prolift].[Fleet#];

Thanks all
PB

 

[Mile-O]

Use the CLng function to convert your text numbers to long integers for the purpose of your query.

NewField: CLng([TextNumberField])

 

[pdbowling]

TY

Many thanks
PB