"Square boxes"

Do these values appear in separate fields in each record in your incoming
data stream?
Name
Address
City, State, Zip
DOB, SSN

If yes, then you can use a query to concatenate the fields into a single
string and output the result (example shown here is for three fields, with a
blank space separting the value from each field):

SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField
FROM TableName;

--

Ken Snell
MS ACCESS MVP




"Blaze" wrote in message
...
Here's what I am doing source to destination:


1. Infopath used to fill out repeating tables, with merge setup.
1b. Repeating Table has 8 fields as described previously.
2. Infopath submit used to post the data to sharepoint services with
merge
on the repeating tables.
3. I use Access to look at the sharepoint site. The data comes in with
the
boxes already there. I think it has something to do with the merge field.
4. I use the query to plug the report into something usable as infopath
is
near worthless except to enter data with integrity.

Now, I have use the build command to do the following: as Fredg provided:

Replace([FieldName],chr(13),chr(13) & chr(10))

This works to do what I needed. Now is there a way to combine:

Name
Address
City, State, Zip
DOB, SSN

One entry per incoming data stream? If not, I can just put two text boxes
with the data source laid out and it would work, just wouldn't be as
"neat"

Thanks for your input on this issue, you've been a real help!

Blaze


"Ken Snell [MVP]" wrote:

This query does not show any concatenation being done in the query, so I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the
data
before the query selects the records.

--

Ken Snell
MS ACCESS MVP

"Blaze" wrote in message
...
Nevermind, found it... This is a simplified version of what I am
doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));


"Ken Snell [MVP]" wrote:

Post the query's SQL statement. It appears that you are using only
half
of
what you need to start a new line. In ACCESS, you use the combination
of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
MS ACCESS MVP



"Blaze" wrote in message
...
I have a query that seperates the fields by "square boxes". I am
pretty
sure
that these are from an unknown character, but how can I find out
what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as
you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson
Jr
The [] is the "square box symbol". When I copy that symbol into
here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

They are in different fields. I'm using the chr(10) & chr(13) command to
seperate the CR's. Can I still do this?

Thanks!

Blaze


"Ken Snell [MVP]" wrote:

Do these values appear in separate fields in each record in your incoming
data stream?
Name
Address
City, State, Zip
DOB, SSN

If yes, then you can use a query to concatenate the fields into a single
string and output the result (example shown here is for three fields, with a
blank space separting the value from each field):

SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField
FROM TableName;

--

Ken Snell
MS ACCESS MVP




"Blaze" wrote in message
...
Here's what I am doing source to destination:


1. Infopath used to fill out repeating tables, with merge setup.
1b. Repeating Table has 8 fields as described previously.
2. Infopath submit used to post the data to sharepoint services with
merge
on the repeating tables.
3. I use Access to look at the sharepoint site. The data comes in with
the
boxes already there. I think it has something to do with the merge field.
4. I use the query to plug the report into something usable as infopath
is
near worthless except to enter data with integrity.

Now, I have use the build command to do the following: as Fredg provided:

Replace([FieldName],chr(13),chr(13) & chr(10))

This works to do what I needed. Now is there a way to combine:

Name
Address
City, State, Zip
DOB, SSN

One entry per incoming data stream? If not, I can just put two text boxes
with the data source laid out and it would work, just wouldn't be as
"neat"

Thanks for your input on this issue, you've been a real help!

Blaze


"Ken Snell [MVP]" wrote:

This query does not show any concatenation being done in the query, so I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the
data
before the query selects the records.

--

Ken Snell
MS ACCESS MVP

"Blaze" wrote in message
...
Nevermind, found it... This is a simplified version of what I am
doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));


"Ken Snell [MVP]" wrote:

Post the query's SQL statement. It appears that you are using only
half
of
what you need to start a new line. In ACCESS, you use the combination
of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
MS ACCESS MVP



"Blaze" wrote in message
...
I have a query that seperates the fields by "square boxes". I am
pretty
sure
that these are from an unknown character, but how can I find out
what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as
you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson
Jr
The [] is the "square box symbol". When I copy that symbol into
here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

Works with the chr(10).

Thank you for the great advise, I was somewhat lost!

Blaze


"fredg" wrote:

On Fri, 5 Aug 2005 13:29:02 -0700, Blaze wrote:

I tried the replace method to see if that helped and I still have the "square
boxes". Should I see if it's just the opposite or is there a way to see the
raw ascii code from the data stream?

Blaze

"fredg" wrote:

On Fri, 5 Aug 2005 12:29:03 -0700, Blaze wrote:

I have a query that seperates the fields by "square boxes". I am pretty sure
that these are from an unknown character, but how can I find out what it is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly, as you can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W Henderson Jr
The [] is the "square box symbol". When I copy that symbol into here, it is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

It probably is a carriage return, chr(13).
Because Access requires both the carriage return as well as a line
space to go to the next line ( chr(13) & chr(10) ), it shows the
return as a square.
What do you want to do with it?

Make it into a real Access new line?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13),chr(13) & chr(10))

Replace it with a space?
Update YourTable Set YourTable.FieldName =
Replace([FieldName],chr(13)," ")

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.


You can check the Ascii of that character, or first try
Replace([FieldName],chr(10),"What ever you want here ")
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

If you can post details about the table's structure, and the fields' actual
contents (examples would be good), I'm sure we can give you a more specific
query to do what you seek. Otherwise, the generic query I suggested earlier
is as much as I can provide at this moment.

--

Ken Snell
MS ACCESS MVP

"Blaze" wrote in message
...
They are in different fields. I'm using the chr(10) & chr(13) command to
seperate the CR's. Can I still do this?

Thanks!

Blaze


"Ken Snell [MVP]" wrote:

Do these values appear in separate fields in each record in your incoming
data stream?
Name
Address
City, State, Zip
DOB, SSN

If yes, then you can use a query to concatenate the fields into a single
string and output the result (example shown here is for three fields,
with a
blank space separting the value from each field):

SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField
FROM TableName;

--

Ken Snell
MS ACCESS MVP




"Blaze" wrote in message
...
Here's what I am doing source to destination:


1. Infopath used to fill out repeating tables, with merge setup.
1b. Repeating Table has 8 fields as described previously.
2. Infopath submit used to post the data to sharepoint services with
merge
on the repeating tables.
3. I use Access to look at the sharepoint site. The data comes in
with
the
boxes already there. I think it has something to do with the merge
field.
4. I use the query to plug the report into something usable as
infopath
is
near worthless except to enter data with integrity.

Now, I have use the build command to do the following: as Fredg
provided:

Replace([FieldName],chr(13),chr(13) & chr(10))

This works to do what I needed. Now is there a way to combine:

Name
Address
City, State, Zip
DOB, SSN

One entry per incoming data stream? If not, I can just put two text
boxes
with the data source laid out and it would work, just wouldn't be as
"neat"

Thanks for your input on this issue, you've been a real help!

Blaze


"Ken Snell [MVP]" wrote:

This query does not show any concatenation being done in the query, so
I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the
data
before the query selects the records.

--

Ken Snell
MS ACCESS MVP

"Blaze" wrote in message
...
Nevermind, found it... This is a simplified version of what I am
doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));


"Ken Snell [MVP]" wrote:

Post the query's SQL statement. It appears that you are using only
half
of
what you need to start a new line. In ACCESS, you use the
combination
of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
MS ACCESS MVP



"Blaze" wrote in message
...
I have a query that seperates the fields by "square boxes". I am
pretty
sure
that these are from an unknown character, but how can I find out
what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly,
as
you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W
Henderson
Jr
The [] is the "square box symbol". When I copy that symbol into
here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze

The only changes are the the Chr(10) came first, so the replace looked like
this:

Replace([FieldName],chr(10),chr(13) & chr(10))

"Ken Snell [MVP]" wrote:

If you can post details about the table's structure, and the fields' actual
contents (examples would be good), I'm sure we can give you a more specific
query to do what you seek. Otherwise, the generic query I suggested earlier
is as much as I can provide at this moment.

--

Ken Snell
MS ACCESS MVP

"Blaze" wrote in message
...
They are in different fields. I'm using the chr(10) & chr(13) command to
seperate the CR's. Can I still do this?

Thanks!

Blaze


"Ken Snell [MVP]" wrote:

Do these values appear in separate fields in each record in your incoming
data stream?
Name
Address
City, State, Zip
DOB, SSN

If yes, then you can use a query to concatenate the fields into a single
string and output the result (example shown here is for three fields,
with a
blank space separting the value from each field):

SELECT [Field1] & " " & [Field2] & " " [Field3] AS OutputField
FROM TableName;

--

Ken Snell
MS ACCESS MVP




"Blaze" wrote in message
...
Here's what I am doing source to destination:


1. Infopath used to fill out repeating tables, with merge setup.
1b. Repeating Table has 8 fields as described previously.
2. Infopath submit used to post the data to sharepoint services with
merge
on the repeating tables.
3. I use Access to look at the sharepoint site. The data comes in
with
the
boxes already there. I think it has something to do with the merge
field.
4. I use the query to plug the report into something usable as
infopath
is
near worthless except to enter data with integrity.

Now, I have use the build command to do the following: as Fredg
provided:

Replace([FieldName],chr(13),chr(13) & chr(10))

This works to do what I needed. Now is there a way to combine:

Name
Address
City, State, Zip
DOB, SSN

One entry per incoming data stream? If not, I can just put two text
boxes
with the data source laid out and it would work, just wouldn't be as
"neat"

Thanks for your input on this issue, you've been a real help!

Blaze


"Ken Snell [MVP]" wrote:

This query does not show any concatenation being done in the query, so
I
must assume that the ComplaintNarrativeOtherNames
field in the Complaint and Witness Forms table/query contains the
concatenated names?

Need to know where the concatenation of the Chr(13) (carriage return)
character is being done, or if the Chr(13) character is already in the
data
before the query selects the records.

--

Ken Snell
MS ACCESS MVP

"Blaze" wrote in message
...
Nevermind, found it... This is a simplified version of what I am
doing.

Select [Complaint and Witness Forms].ID, [Complaint and Witness
Forms.ComplaintNarrativeOtherNames
From [Complaint and Witness Forms]
Where ((([Complaint and Witness Forms].ID)=[ID])));


"Ken Snell [MVP]" wrote:

Post the query's SQL statement. It appears that you are using only
half
of
what you need to start a new line. In ACCESS, you use the
combination
of
Chr(13) & Chr(10) for a new line (carriage return and line feed,
respectively).
--

Ken Snell
MS ACCESS MVP



"Blaze" wrote in message
...
I have a query that seperates the fields by "square boxes". I am
pretty
sure
that these are from an unknown character, but how can I find out
what
it
is?
Here is an example of what I want:

Michael S Parrill
Jessica L Davis
Cody A Phipps
David W Henderson Jr

When I copied and pasted it from my query it shows up correctly,
as
you
can
see above, the query looks something like this:
Michael S Parrill[]Jessica L Davis[]Cody A Phipps[]David W
Henderson
Jr
The [] is the "square box symbol". When I copy that symbol into
here,
it
is
treated as a carriage return.

Help, as I'm going nuts on this!
Blaze