Scotty,

Copy/Paste the SQL of the query here...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"scott04" wrote in message
news
I am not sure what you mean by distinct but there is not any grouping in
the
query.

"Gina Whipp" wrote:

Scott,

Are you using DISTINCT in your query?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"scott04" wrote in message
...
Gina,

I first tried just pulling my report. Then clicked export and tried to
dump
data in excel 1997-2003 and the other version of excel. It cut off
probabbly
after 255 characters when it transfered it to excel.

I have tired the transferspreadsheet method but that did not seem to
work
for me. I was thinking there had to be an easier way then what i was
doing.
The only time it fully copied everything is when i transfered the query
to
XML. When i did that it kept my entire memo field. I do not want to
have
in
in XML since my end user really just needs it in excel.



"Gina Whipp" wrote:

Scott,

You say some of the text is cut off... Are you trying to export a Memo
field? How much is some? How are you exporting...
TransferSpreadsheet?
Do
you have an Export Specification?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"scott04" wrote in message
...
Hi everyone,

I am using access 2003 and am trying to export a report that comes
from
a
query to excel however some of the text is cut off. I have read
others
problems but couldnt find the shoe that fit. Can someone help? Can
i
have
some sort of marco that runs my query and then dumps it into excel
fully?
If
so please explain. Thanks for your help!

Scott


.



.