DrSeussFreak
Programmer
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?