VB Code or Query design for Machine capacity calculation

[Vanita]

Hi,

1. I have to calculate machine capacity for the 2 selected(random) dates.
2. Have given the data available in the below table mentioning machine installed date etc.
3. Report/Query shall ask for 2 dates which user enters as per the requirement.
4. For ex: For given dates of 01/10/17 and 01/07/18 (User shall enter the required dates) i have Turning machines 2 and Milling Machines 2 Nos.
5. Capacity(Turning)=273 days*2 Machines*22.5


6. Capacity(Milling)=273 days*2 Machines*22.5

Can you please help me out to design it!

Thanx in advance!

[CJ_London]

use datediff to determine the number of days (or subtract one from the other) which will give you your 273

you need to be clear about date formats - your table shows 01-Dec-16 which is quite clear, whilst your from/to dates are 01/10/17 - is that 1st October or 10th Jan?

[orange]

Do the machines operate 24 x7 ? (no weekends, no holidays, no downtime for maintenance?)