I am trying to create a report using two tables. The problem is that the field in the field in the one table has trailing spaces and the other tables does not. For example, the one table has Item ABC123 and the other table has Item ABC123 with 10 trailing spaces. If I link the tables as is, I get no records. Is there a way to create a link using a 'Trim' statement??
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.