How to get these results in cross tab query

[rehanemis]

Hello,

I have thousands of records (as dummy data is attached in ms access file). I just want to get the desire results by summing up products by Day and Type.

Please check the snap shot attached.

Is there any way to do it using cross-tab query or other.?
any idea?

Thanks

 

[plog]

You can't do a cross-tab to get those results. Cross-tab will convert 1 field at most to column headings. I suggest a pivot table in Excel for what you want (https://support.office.com/en-us/ar...eet-data-a9a84538-bfe9-40a9-a8e9-f99134456576).

Create a query in Access to generate the data you need. Paste it into one tab of Excel, then on another make the pivot table. It will allow multiple fields to be used as columns.

 

[JHB]

Try the 2 queries in the attached database, maybe it could satisfy you.