|
| 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 |
|
#1
July 29th, 2009, 09:31 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Analyze It with MS Office Excel
Hello, I have a Access 2003 report, one of the fields on the report display
data like 09-4952 they then use the "Analyze It wtih MS Office Excel" feature, when this value gets to Excel it looks like 1114966. Is there any properties I can set to keep the 09-4952 Thanks 
|
|
#2
July 30th, 2009, 04:10 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Analyze It with MS Office Excel
Don,
I'm not expert on MS-Excel, however it seems Excel is interpreting 09-4952 as a date. The integral value for the date 1st Sep 4952 is 1114966. Would be worth a try to convert the 09-4952 field to a string (using Str() in your query) and see if that causes Excel to also see the value as a string. HTH Sam "Don" wrote in message ... Hello, I have a Access 2003 report, one of the fields on the report display data like 09-4952 they then use the "Analyze It wtih MS Office Excel" feature, when this value gets to Excel it looks like 1114966. Is there any properties I can set to keep the 09-4952 Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
