Newbie Question

[Legend1673]

Should be easy to find the answer but...



I have table "Results" with Columns "Cat1" & "Category"

When running code, I need to populate the first word of "Cat1" into "Category" (Cat1 is multiple words long)

What am I missing...

Thanks,
Jeff

[pbaldy]

Check out the Left() function, along with the InStr() function to find the first space.