Need to add a space in an insert query

[jax1000rr]

I cannot seem to get the syntax correct to add a space between "HMDA disposition changed:" and & Disposition().

Help please...

DoCmd.RunSQL "INSERT INTO tblCommLog ( FileNumber, Date_Time, Comm_Subject, User, Content )" & _
"SELECT [Forms]![frmProcessingQueue]![FileNumber] AS Value1, Now() AS Value2, 'Record Edited' AS Value3, fOSUsername() AS Value4, 'HMDA disposition changed:' & Disposition() AS Value5;"

[jax1000rr]

Figured it out...

DoCmd.RunSQL "INSERT INTO tblCommLog ( FileNumber, Date_Time, Comm_Subject, User, Content )" & _
"SELECT [Forms]![frmProcessingQueue]![FileNumber] AS Value1, Now() AS Value2, 'Record Edited' AS Value3, fOSUsername() AS Value4, 'HMDA disposition changed:' & SPACE(1) & Disposition() AS Value5;"

[pbaldy]

You can simply add a space to the preceding string:


'HMDA disposition changed: ' & Disposition() AS Value5

or

'HMDA disposition changed:' & " " & Disposition() AS Value5

but the first is the most efficient.