Reporting like excel

[dio.m]

Hello all,
Is it possible to make a report like Ms. Excel.
here is the sample of excel files.

Thanks,

Dio

 

[Trevor G]

Can you upload some sample data in a database rather than spreadsheet, you would need queries and then some extra calculations on the report but could be done.

 

[dio.m]

Thanks for the quick reply, I'm new with access, Anyway here is my sample data like you asked for. I would be grateful if you can help me with this.

With many thanks,

Dio

 

[Trevor G]

Having looked at your database briefly,

Create a new report based on your query myQuery, use the Report Wizard as it will allow you to use Groupings and Group by week number. Then as you move through the wizard you can also get summary options where you can total by the Product Amount.

This gives you the basis of what you have asked for.

Finally back in the query add a Total and group by date and sum product.

 

[dio.m]

Thanks for your reply, but I already know how to make the report like you explained to me. But how about to make the report to look like the Excel File that I attached.
Better to use the 'tmp' Query to get the plant name. Can you help me? I really need this kind of report.

Thanks in advance

 

[dio.m]

Hey ... I got it .. i use cross tab query ... Anyway can I ask some more if i have difficulties on this.

With many thanks

Dio