Live Permits Per Day

[Pharaoh]

Hi,

I am trying to write a query to show how many Permits are active on each day of a financial year. In my table I have Permit ID & Expiry Date fields.

I am looking to have a list of days of the year with a count of how many permits were still active on that day.

Any help with writing a query for this would be greatly appreciated.

Thanks

Pharaoh

 

[Trevor G]

Hi,

I am trying to write a query to show how many Permits are active on each day of a financial year. In my table I have Permit ID & Expiry Date fields.

I am looking to have a list of days of the year with a count of how many permits were still active on that day.

Any help with writing a query for this would be greatly appreciated.

Thanks

Pharaoh

I would place a Yes/No field in your table and you can count on them with your expiry date field.

So create a query on the yes/no field then group and count if the yes/no field is true and use the date field as well you will get a return how many yes based on each date