Is it the Notes field that is the Memo field?

--
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
...
SELECT [Ask PMQS].Status, [Ask PMQS].Date_Received, [Ask PMQS].Topic, [Ask
PMQS].[Question Category], [Ask PMQS].Question, [Ask PMQS].Answer, [Ask
PMQS].[CRS Training/Help Site Resource], [Ask PMQS].Notes
FROM [Ask PMQS]
WHERE ((([Ask PMQS].Status)=3) AND (([Ask PMQS].Date_Received) Is Not Null
And ([Ask PMQS].Date_Received) Between [Please enter start date] And
[Please
enter end date]));

"Gina Whipp" wrote:

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


.



.



.