Remove a Gap

A

Allison

5-CR19AI46130-6 -5651 (wrong)

1-RT1AI59401-1-5751 (should appear like this)

2-RZ1AI30464-13A1-5751 (or it may appear like this)

The above numbers are concatenates of other fields
the field is entitled Account Number.

How can I remove the Gap in the first example?

By the way this is how the field appears in my make table
query:
Account Number: [TYPE] & "-" & [ACT] & "" & [AI] & "" &
[GRANT] & "-" & [YR] & "" & [SUPP] & "-" & Right([CAN]
 
B

Bob T

Use the TRIM function in the MAKETABLE query. Works fine if the field is text

Account Number: TRIM([TYPE]) & "-" & TRIM([ACT]) & "" & [AI] & "" &
TRIM([GRANT]) & "-" & TRIM([YR]) & "" & TRIM([SUPP]) & "-" & TRIM(Right([CAN])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Creating Different Headers in Word 0
Page numbering with Merged Document and IF statements 1
Input Mask 1
Displaying time gaps 6
month gaps counting through whole column 15
Dates Validation for Overlapping & Gaps (Leo asked) 2

Top