Access to Excel Field Conversions...

[jhansen]

Hello

I am trying to export a report from Access to Excel, which is based upon a query and I'm having a problem.

I have one expression based upon 2 fields. The end result looks something like this:
"1.01.03"
When I export this, Excel converts it to a decimal eg: 0.2346465656. Not very useful. I've tried to change the properties of my expression in my query to all sorts of different types (eg: time/date/scientific), but since "text" isn't one of my options, the same thing is happening.

Once I export to Excel, I can change my cell property to "time" and it works (except I've got ":"'s where my "."'s should be). I'd rather not have to convert after exporting.

Does anyone have any suggestions?
j.

 

[Mario]

Convert your field in Access to a string and then export it to text cell in Excel... That'll work for sure

 

[jhansen]

doesn't seem to like to do this. any suggestions on syntax? I keep getting error messages.

 

[Mario]

What is exactly your expression in the report?
Is it a textbox (probably)?
If so, How do you write this expression in the report?
With a macro or with VB?

To have the properties set to text for a textbox make sure you have the ". For example, set your control source to :

="Try some text" and it will be considered as text.

Give me some answer and I'll try to make it clearer after.

 

[jhansen]

My expression is merging two fields. one is a text field, but contains numbers like 1.23 and 1.23.1. the other is a number field 1,2,3,etc.
these are merged in my report to read:
1.23.1 for room numbers.
I want it to read like text to excel, but unless I add a letter to each one, its reading it like a number.
I thought that maybe if I added one record that has alpha values for the text in it, excel would read all the records as text, but no such luck.
It seemed like such a good idea, but now.>>>>
?

 

[Mario]

can you post your code? It'll be better for me to see it...