Ravi Kumar
Registered User.
- Local time
- Tomorrow, 01:09
- Joined
- Aug 22, 2019
- Messages
- 162
Dear all ,
I have a table which has the data of daily rework qty of 5 different categories(types) , I need two modifications to complete this so please help me:
1. I have a query which summarizes the data day wise , but I need an extra query which summarizes the same in month wise.(month by categories(type))
day wise query SQL -
SELECT DISTINCTROW Format$([Master Table].[Date of Entry],'Long Date') AS [Date of Entry By Day], [Master Table].Type, Sum([Master Table].[Inspected Qty]) AS [Sum Of Inspected Qty], Sum([Master Table].[Rework Qty]) AS [Sum Of Rework Qty]
FROM [Master Table]
GROUP BY Format$([Master Table].[Date of Entry],'Long Date'), [Master Table].Type;
2. I have made a chart which is currently only showing sum of inspection qty daily , but how to get a line graph in the secondary axis showing rework percentage of that day.
I have attached the database for your reference.
I have a table which has the data of daily rework qty of 5 different categories(types) , I need two modifications to complete this so please help me:
1. I have a query which summarizes the data day wise , but I need an extra query which summarizes the same in month wise.(month by categories(type))
day wise query SQL -
SELECT DISTINCTROW Format$([Master Table].[Date of Entry],'Long Date') AS [Date of Entry By Day], [Master Table].Type, Sum([Master Table].[Inspected Qty]) AS [Sum Of Inspected Qty], Sum([Master Table].[Rework Qty]) AS [Sum Of Rework Qty]
FROM [Master Table]
GROUP BY Format$([Master Table].[Date of Entry],'Long Date'), [Master Table].Type;
2. I have made a chart which is currently only showing sum of inspection qty daily , but how to get a line graph in the secondary axis showing rework percentage of that day.
I have attached the database for your reference.