Select statement in Excel VBA to Access Database

[comconrk]

I have been using a simple select statement in a VBA macro

querystring = _
"SELECT Project_Number,Desc,Designer,Product_Type,On_Sale_Date,Product_Code,Pages FROM Filemaker WHERE (Project_Number=" & Proj_Truncated & ")"

It has been working very well until now, when the Project_Number has now been changed from numeric to alpha in the Access database. When I did an Excel Query and looked at the SQL code I did see that it put single quotes around the Project Number. However, that does not seem to work when I use the above statement. Since it has been working well, I am not certain what to do from here. I would appreciate any help.

Thanks very much

 

[Fherrera]

When you say you added the single quotes to the project number you mean:

WHERE (Project_Number= '" & Proj_Truncated & "' )"

Right?

 

[comconrk]

I actually embedded the single quotes in Proj_Truncated, so
445566 now is '445566'.

 

[Fherrera]

Hrm, I thought Proj_Truncated was an integer or something. Perhaps hardcoding it like I suggest may help?? (You never know sometimes..)

 

[comconrk]

Thanks,

I will try that.