i use the following code in VBA / SQL inorder to pull out all fields with ids required.
FOHF_table.fld_tier_level IN (" & IDs_required & ")
i wish to do the same for a another field however when in the above example i can say IDs_required= 1
However now i wish to say Filed_required = abc ZYX
Vba does not like the space between the abc and xyz. ( in the SQL i can simply put 'abc xyz') do i have to rename the things in the database? abc_xyz.?