Report exporting different data from what is on the report

  • Thread starter Thread starter sk
  • Start date Start date
S

sk

I have a standard Access 2007 report (based on a query) in my database that
pulls information on a specific item. The report runs fine but when the user
right clicks on the report and exports to Excel, they get the information for
a different item. I had them delete the export file and try renaming it.
Neither worked. The item they are getting information on is one that they
exported prior. Now it is the only record that will export, regardless of
what the report is showing.

Help Please.
 
SK -

Since I have never seen this, I wonder if it is one of those user errors
where we just forget something simple. Are you sure you are checking the
correct export file (check the date/time stamp before opening it). It could
be the user forgot to select the Excel file type from the Export dialog box,
and it really exported a database object with the same name (but you are
looking for Excel and opening the old one). Or maybe the subdirectory is
wrong. Or there is a typo in the exported file name.

Does this happen with all reports? Just this user?

I don't have Access 2007, so I can't tell if there is something going on
there - just looking at the normal things to try...
 
Back
Top