Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access: Text to Number for Query

Status
Not open for further replies.

DrSeussFreak

Programmer
Feb 16, 2007
149
US
Code:
INSERT INTO sites ( [tax id], [street number], [street name], [footprint area], [gross area], [property area], [number of units], [number of bedrooms], [number of parking spaces], [cha required], [doh required], [green permit program], [department of planning and development required], [you are the owner], [you are the developer], [Green Roof sf)], [energystarr roof (sf)], [recycled content roof (sf)], [protected/restored habitat (sf)], [conserved open space (sf)], [native landscape (sf)], [rain garden (sf)], [permeable materials (sf)], [number and size of rain barrels] )
SELECT topmostSubForm.[PLI-TAX], CInt(([topmostSubForm].[PLI-STR-NUM])) AS [PLI-STR-NUM], topmostSubForm.[PLI-STR-NAME], topmostSubForm.[PI-FPA], topmostSubForm.[PI-GA], topmostSubForm.[PI-PA], topmostSubForm.[PI-UNITS], topmostSubForm.[PI-BEDS], topmostSubForm.[PI-PARK], topmostSubForm.[CATA-CHAR], topmostSubForm.[CATA-DOHR], topmostSubForm.[CATA-GPP], topmostSubForm.[CATA-DPDR], topmostSubForm.[CATA-OWN], topmostSubForm.[CATA-DEV], topmostSubForm.[API-GR], topmostSubForm.[API-ESR], topmostSubForm.[API-RCR], topmostSubForm.[API-PRH], topmostSubForm.[API-COS], topmostSubForm.[API-NL], topmostSubForm.[API-RG], topmostSubForm.[API-PM], topmostSubForm.[API-RB]
FROM topmostSubForm;

I am trying to run this query, but I need to convert a text field into a number field.

Code:
CInt(([topmostSubForm].[PLI-STR-NUM]))

is not working, any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top