hi,
From below query access2016, i need to represent the data (attached) in a chart.
Which chart types can i use to represent the details?
SELECT tbl_customer.customerName, Count(tbl_customer.customerName) AS COUNT_PER_customer, tbl_customer.Status, tbl_customer.SEGMENT
FROM [tbl_customer]
WHERE (((tbl_customer.SEGMENT) Is Not Null))
GROUP BY tbl_customer.customerName, tbl_customer.Status, tbl_customer.SEGMENT;
From below query access2016, i need to represent the data (attached) in a chart.
Which chart types can i use to represent the details?
SELECT tbl_customer.customerName, Count(tbl_customer.customerName) AS COUNT_PER_customer, tbl_customer.Status, tbl_customer.SEGMENT
FROM [tbl_customer]
WHERE (((tbl_customer.SEGMENT) Is Not Null))
GROUP BY tbl_customer.customerName, tbl_customer.Status, tbl_customer.SEGMENT;