|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#11
October 29th, 2009, 05:50 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Trying to Export Report to Excel 2003
Actually it is the Question field the dept wanted a memo field.
"Gina Whipp" wrote: 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 inthe 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 . . . . 
|
|
#12
October 29th, 2009, 05:59 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Trying to Export Report to Excel 2003
Scott,
Okay but is [[Ask PMQS] a query? And what version of Excel do you have, you said Access 2003 but not spedify Excel version? I have tried this using TransferSpreadsheet and File|Export and have been successful both times, whether I open in Excel 2003 or Excel 2007. -- 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 ... Actually it is the Question field the dept wanted a memo field. "Gina Whipp" wrote: 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 . . . .
|
|
#13
October 29th, 2009, 06:03 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Trying to Export Report to Excel 2003
It is a table
"Gina Whipp" wrote: Another question... is Ask PMQS a table or query? If it is a query what is the SQL of that query? -- Gina Whipp
|
|
#14
October 29th, 2009, 07:43 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Trying to Export Report to Excel 2003
Gina,
I am using excel 2003 as well...if i run the query all along i get all of the data from the memo field. I do not get the data when i transfer or export as it cuts at 255 characters. Using the mid function in the query from (1, 255) then (256, 500) works but does not look nice since sometimes words are cut up. "Gina Whipp" wrote: Scott, Okay but is [[Ask PMQS] a query? And what version of Excel do you have, you said Access 2003 but not spedify Excel version? I have tried this using TransferSpreadsheet and File|Export and have been successful both times, whether I open in Excel 2003 or Excel 2007. -- 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 ... Actually it is the Question field the dept wanted a memo field. "Gina Whipp" wrote: 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 . . . . .
|
|
#15
October 29th, 2009, 07:56 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Trying to Export Report to Excel 2003
Scott,
Okay, I am getting stumped becase as I said, I ran some tests and cannot duplicate... Let's try this, what happens if you use TransferSpreadsheet on the table? Also, copy/paste the TransferSpreadsheet line you are using 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 ... Gina, I am using excel 2003 as well...if i run the query all along i get all of the data from the memo field. I do not get the data when i transfer or export as it cuts at 255 characters. Using the mid function in the query from (1, 255) then (256, 500) works but does not look nice since sometimes words are cut up. "Gina Whipp" wrote: Scott, Okay but is [[Ask PMQS] a query? And what version of Excel do you have, you said Access 2003 but not spedify Excel version? I have tried this using TransferSpreadsheet and File|Export and have been successful both times, whether I open in Excel 2003 or Excel 2007. -- 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 ... Actually it is the Question field the dept wanted a memo field. "Gina Whipp" wrote: 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 . . . . .
|
|
#16
November 4th, 2009, 08:51 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Trying to Export Report to Excel 2003
Gina it looks like i finally got the query to transfer entirely. I do have
an issue when it transfers over the column that was greater than 255 charcters is showing up as ##################################. When i click in the cell it shows me the content but i am still working on getting that issue resolved. Thanks "Gina Whipp" wrote: Scott, Okay, I am getting stumped becase as I said, I ran some tests and cannot duplicate... Let's try this, what happens if you use TransferSpreadsheet on the table? Also, copy/paste the TransferSpreadsheet line you are using 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 ... Gina, I am using excel 2003 as well...if i run the query all along i get all of the data from the memo field. I do not get the data when i transfer or export as it cuts at 255 characters. Using the mid function in the query from (1, 255) then (256, 500) works but does not look nice since sometimes words are cut up. "Gina Whipp" wrote: Scott, Okay but is [[Ask PMQS] a query? And what version of Excel do you have, you said Access 2003 but not spedify Excel version? I have tried this using TransferSpreadsheet and File|Export and have been successful both times, whether I open in Excel 2003 or Excel 2007. -- 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 ... Actually it is the Question field the dept wanted a memo field. "Gina Whipp" wrote: 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 . . . . . .
|
|
#17
November 4th, 2009, 08:57 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Trying to Export Report to Excel 2003
Scott,
First let me say, glad that got worked out! Now, as for the 255 character limit (I assuming here you're talking about the column heading), that is an Access limit so not sure how you are going to get around that. Any way you can shorten those column headers? -- 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 it looks like i finally got the query to transfer entirely. I do have an issue when it transfers over the column that was greater than 255 charcters is showing up as ##################################. When i click in the cell it shows me the content but i am still working on getting that issue resolved. Thanks "Gina Whipp" wrote: Scott, Okay, I am getting stumped becase as I said, I ran some tests and cannot duplicate... Let's try this, what happens if you use TransferSpreadsheet on the table? Also, copy/paste the TransferSpreadsheet line you are using 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 ... Gina, I am using excel 2003 as well...if i run the query all along i get all of the data from the memo field. I do not get the data when i transfer or export as it cuts at 255 characters. Using the mid function in the query from (1, 255) then (256, 500) works but does not look nice since sometimes words are cut up. "Gina Whipp" wrote: Scott, Okay but is [[Ask PMQS] a query? And what version of Excel do you have, you said Access 2003 but not spedify Excel version? I have tried this using TransferSpreadsheet and File|Export and have been successful both times, whether I open in Excel 2003 or Excel 2007. -- 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 ... Actually it is the Question field the dept wanted a memo field. "Gina Whipp" wrote: 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 anygrouping 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 . . . . . .
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
