Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: niwot
  • Order by date
  1. niwot

    Remove trailing spaces from all fields with code

    I see how this will work field by field in a query but is there any way to do it code, iterating through a list of tables/fields? Thanks for the iif code if I have to do it in queries this will keep the query from crashing. Thanks again.
  2. niwot

    Remove trailing spaces from all fields with code

    Have to import fixed width fields from old FoxPro. All field data must be trimmed. Lots of tables and many fields. Tried trim() in update query but it quit when it found a few records with actual spaces and nothing else. I guess you can't trim if there is nothing to trim against. Anyway can find...

Part and Inventory Search

Back
Top