VBA SQL won't run because of custom field name

[anovak]

I've got the following SQL statement that won't execute in a VBA
script because the custom field referenced by the view is "Service
Area", not "Service_Area" or "ServiceArea" (there is a space in
between)


rs2.Open "Select MemberValue FROM 'MSPLT_Service Area_UserView' ORDER
BY MemberValue", Conn

Anyway I can cod this to "excuse" the space or do I have to rename the
custom field to "Service_Area" or "ServiceArea"?

Thanks,
Andy Novak
UNT

 

[Marc Soester [MVP]]

Hi Andy, may be worth posting to the development group. You may be more lucky
with an answer

 

[Ray McCoppin]

In SQL you can use square brackets "[]" to enclose any names of tables,
fields that have should problems. So the syntax for you query would be like
this:

..... FROM [MSPLT_Service Area_UserView] .....

Hope this helps

--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts
Project Server 2007 Archive tool