"Square boxes"

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

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

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.

Stupid question... How do I show you the SQL Statement?

"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

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

Well, I would like to join two different fields for this reason.

Query returns 8 pieces of information.

1. Name
2. Address
3. City
4. State
5. Zip
6. Phone
7. SSN
8. Date of Birth (DOB)

Each of which are in their own field. So the example I had earlier just
showed the Name information. So the end result would show, if possible.

Name, DOB
Address, City, Zip,
Phone, SSN

In the "array" each entry in the field is seperated by one of the "square
boxes".

If that doesn't work, I just want carraige returns between the names, so
that I can allign the names, Addresses, DOB, etc. It would create a "false"
resolution, but would work for what I am doing.

Thanks for the input!

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.

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.

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

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

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.