Showing the required table in report

[fahimnaimi]

How can i make similar to this content in a table of excel to my report in access.

[June7]

Probably won't be easy.

Depends on your data structure. We really can't advise specifics without knowing more about your db.

Looks like may need CROSSTAB queries. Review http://allenbrowne.com/ser-67.html

[fahimnaimi]

June7,

I did cross tab and to some extent it worked, but the difficult part is the Change (Unit and %) since i need to subtract 2015-Q3 from 2015-Q2 that is under one field (Quarter). Also in cross tab i can calculate only one field and not more that that in one cross tab query.

[fahimnaimi]

Here is my db. having a table MV DB.accdb

[June7]

You have the CROSSTAB that gives the numbers by year/quarter. Now use it in another query (or as a report RecordSource) that does the arithmetic with the fields.

Problem with CROSSTAB is you will have to edit the second query (or report) every quarter because the fieldnames change and the expressions will no longer work.

You did not include attempted queries in the db. Post the SQL statement of query.