Setting fields in a make table query

[IANGRAND]

I have written a make table query which exports a series of addresses with an associated Easting and Northing. The idea is to link this new table to GIS using the two coordinates. However presently the easting and northings are saved as a text field, and to use them i need the new table to display them in a numeric field, which presently i need to manually alter. Is there any way through a query to set the easting and northing field for the new table to numeric?

Cheers

Ian Grand

 

[KenReay]

Hi

You mean like:

EastingAsNumber:Val([Easting])

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[IANGRAND]

How would you use this method, would it be in the sql of the query?

 

[PHV]

In the query you may use the CLng, CDbl or Val functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[KenReay]

Hi

In the Query design gridt it would appear so

EastingAsNumber:Val([Easting])

in SQL view

SELECT .... ,Val([Easting]) As EastingAsNumber FROM ...

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK