Data changes when exporting a report to Excel

Guest

Posts: n/a

13th May 2010

Using Access 2003 SP3

When I export or send as an attachement a report some of the data (numeric)
changes. The field that changes is the upper level grouping of the report.
For instance the number in the report will be 1-1531771657, the number in the
exported excel workbook is -427697. This happened in 4 of seven records, the
other 3 were ok.

The data source is a Select Query.

Any ideas?
--
PRD

« Need help: table with all locations AND just one location | Total not correct in Footer »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Little problem when exporting a report to Excel: all data is expor	The Dude	Microsoft Access Reports	0	10th Mar 2008 02:58 PM
exporting data from a report in to excel using a template	=?Utf-8?B?TWF0dA==?=	Microsoft Access Form Coding	0	20th Aug 2007 11:36 PM
Exporting data from Crystal Report to Excel - Need soln	=?Utf-8?B?QW5peWFuX1JlbW8=?=	Microsoft Excel Programming	0	29th Jun 2005 10:29 AM
Exporting Access 2002 Report to Excel - data changes	Lisa	Microsoft Access Getting Started	0	15th Jul 2003 02:44 PM
HELP: Problem with exporting Access Report data to Excel	Big Gee	Microsoft Access VBA Modules	0	9th Jul 2003 02:53 PM