Hi there I have serveral tables that come from a SQL server. When the tables are linked to Access most of the fields have spaces before and after the data. In each table there is just too many fields to use the trim([field name]) on all of them. Is there a function that can update all the fields at once? Also is there a way that when the SQL tables are import or linked that the fields are automatically trimmed without having to do this if the trim all fields is not available. Thank you so much.
This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.