Report Export to MS Excel is not correct

[TJBernard]

I am not sure if anyone has run into issues with MS Access Reports exporting to MS Excel but I have run into a silly situation.

I have a query that combines two fields (Beg Bates) and (End Bates) so that the format for the field = Beg Bates " - " End Bates. Then on the report the two fields combine correctly to equal one Bates Field. Everything works just fine.

But when I export this report to Excel for some reason it changes some of the "Bates" fields into a number, but leaves most of them set up like they are supposed to be. I cannot find a pattern within the data that would cause this to occur, and I cannot find a property that is set up incorrect.

Here is some examples, maybe someone will recoginize an ascii code or something:

MS Access Report: Excel Export Results:
AMB 00001 - 00157 -636615
AMB 00158 - 00303 AMB 00158 - 00303
AMP 00001 - 00014 37270
AMP 18794 - 18808 AMP 18794 - 18808
00625 - 00660 00625 - 00660
00001 - 00624 -466048

I can not see a patern, but if someone has run into errors with exporting MS Access Reports to MS Excel, let me know of any possible ideas.

Thank you very much for your time.

T.J.

 

[cpod]

It would seem that Excel is interpreting some of them as dates.

If you notice in your third example:

00001 - 00014 37270

the number 37270 is how MS programs store the date Jan 14, 2002 or:

1-14-02

What happens when it tries to reconcile the 157th day of January is anyone's guess:

00001 - 00157 -636615

To fix it you could try:

=cstr(Beg Bates) & " - " & cstr(End Bates)

 

[TJBernard]

Wow, that is something I didn't notice with the possibility of the Excel spread sheet reading it as a date. Thank you very much, I now have a new angle to work with.

Thank you for your time.

T.J.