SQL statement

[amypaulsen]

Below is the sql statement that I am using within my code. I am using a SQL statement to select certain criteria out of Access. I keep getting a compile error message right after "TOTAL" that says Expected: end of statement. I tried putting in an underscore to account for the spaces and then the error comes after the ":", right on the underscore (right before 7110-4499) saying "invalid character". Please bear with me as access really isn't my thing!

strSQL = "SELECT qryFlash05.UNIT, qryFlash05.category, qryFlash05.[" & WeekNum & "] from [qryFlash05] where category = '" & TOTAL CONTROLLABLE COST : 7110.4499 & "';"

Thanks!!!

 

[Norie]

Does this work?

strSQL = "SELECT qryFlash05.UNIT, qryFlash05.category, qryFlash05.[" & WeekNum & "] from [qryFlash05] where category = 'TOTAL CONTROLLABLE COST : 7110.4499';"