Calculate percentages over a period of time in a microsoft access query (1 Viewer)

[wire_jp]

Hello Everyone,

I am using Microsoft Access 2013. I am trying to calculate percentages over a period of time in a microsoft access query.

 

[Ranman256]

Make Q1 sum /count the values in that date range.
Then make Q2 that uses Q1 and the data table to sums/count the data per day (in the range )
Q2 can now do the percent.

 

[wire_jp]

Hello Ranman256,

Can you kindly provide me with the code to sum the values within the date range?

Thanks,

wire_jp