Access 97 to Excel 2003 (97)

Topic

New Reply

Check the Top property of the controls in the Detail section of the report – is it the same value for all of them?

Why don’t you export the query to Excel instead of the report, and create the subtotals there?

Reply | Quote

Replies

Thanks for the solution, Hans – seems that the Top property on the two columns that were out of order were just slightly different from the others. Once I fixed those so all columns had the same top position, the report exports now in the correct order.

As for exporting the query (hadn’t thought about that) it’s simpler to export the report. To get at the query I have to open a separate report writer program and then would have to insert group totals whereas the report is generated from within the accounting program and already has the group totals.

Rod

Reply | Quote

Not sure if this is an Access or Excel issue but since it starts with Access, I’ll post it here.

I use an accounting program that is built using MS Access 97 as the database. We haven’t upgraded it to to be compatible with later version of Access (long story – don’t ask why!)

One of the reports that I created and use regularly needs to be exported to an Excel 2003 spreadsheet for some additional “tweaking” and when I export the report, I get some of the columns coming up in the wrong order. Wondering if anyone knows why this is happening? I’ve put some screen shots in a PDF file you can see here: [Link deleted – no longer required]

Note that columns B & C in the spreadsheet are in the wrong location. It’s simple to cut & paste them into the right locations but wondering why this happens in the first place? One would think that Microsoft office applications would be compatible with each other.

Reply | Quote