User Profile

Collapse

Profile Sidebar

Collapse
danield
danield
Last Activity: Oct 22 '08, 09:04 PM
Joined: Oct 14 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • danield
    replied to How to remove leading spaces?
    in Access
    Hello NeoPa,

    Thank you very much for this information. I will try it out.

    danield
    See more | Go to post

      Leave a comment:

    • danield
      replied to How to remove leading spaces?
      in Access
      Hello DonRayner,

      Thank you very much. Ltrim does exactly what I need :)

      danield...
      See more | Go to post

        Leave a comment:

      • danield
        started a topic How to remove leading spaces?
        in Access

        How to remove leading spaces?

        Hello All,

        I have a query that I use to create another table:

        Code:
        SELECT	column1 & " " & column2 INTO table2
FROM		table1
        The problem is that sometimes there is no value in column1 and then the new entry in table2 is 'space' and then column2. For example if first column has '1' and second column has '2', the new record in the table2 would be '1 2' but if another row...
        See more | Go to post
        No activity results to display
        Show More
        Working...