VBA / SQL field names with spaces

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.?
Who is Participating?
BeyondWuConnect With a Mentor Commented:
test to say Filed_required = [abc ZYX]
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.