access thread: Append query is adding spaces
Message #1 by "Peter Duke" <peteydukie@y...> on Thu, 16 Aug 2001 22:01:07
|
|
I have an append query (as a SQL statment)that is adding a leading space
to all the fields of the table. Any ideas why its doing this? Its making
it hard for me to match up fields.
Message #2 by "Richard Lobel" <richard@a...> on Thu, 16 Aug 2001 15:44:30 -0700
|
|
Please post the SQL statement you are using.
Richard Lobel
Accessible Data
richard@a... <mailto:richard@a...>
Cell: (xxx) xxx-xxxx
Fax: (xxx) xxx-xxxx
>I have an append query (as a SQL statment)that is adding a leading
space
to all the fields of the table. Any ideas why its doing this? Its
making
it hard for me to match up fields.<
Message #3 by "Peter Duke" <peteydukie@y...> on Fri, 17 Aug 2001 00:58:02
|
|
Thanks Richard,
I had been adding a space myself in the code:
' " & textbox & " ' instead of '" & textbox "'
|
View Cart
