Hello everyone here

I wanna ask about converting report into a table! (It does not matter wether it is an Excel or Access table

I did something but It does not work fine

I opened the targeted report in preview mode and then I selected :

File---->Export ----> (file name bla bla bla ) & (Save as type MS Excel 97 - 2000)

but when i open the created file in MS Excel I get it disorganized and there is only one field , but i can't see the rest of the fields

Any help??

Export the dat contained in the report, that is, the report record source , not the report itself. If you have subreports, you've got a bigger problem.

Maybe your report is ending up in one column of an Excel sheet. I've never exported a report like you're apparently saying, I export data. Yeah, I know, one has to reformat it. I've done that too.

well, thanks 4 ur help
but i don't really understand, how to export the data source and not the data itself?

by the way, it does not have a subform, but it has a lot of calculated fields in addition to that the report has some groupings and hidden fields!

Export the data, the recordsource, using the TransferSpreadsheet Action (see the Help menu). Perform you calculation in the query or in Excel after the data has been exported.