Problem with percentages

[Fisher]

Hi.
I have a database where an admission date and a discharge date are entered on a form. From this I calculate the Length of stay. What I'm having trouble with is creating a query that calculates how many have a Length of stay of less than seven days, 8 - 10 days, 11-14 and >14, along with the percentage each category is of the whole. It's the percentage that really has me going in circles. I would appreciate any help with this.
Thanks

 

[dcx693]

Read this post: Age bracket query.

 

[Fisher]

I did a search and didn't find the previous post.
It didn't occur to me to create an additional table to define the ranges. Looking at it, I think that will do the trick.
Thanks so much for your help.

 

[dcx693]

Good luck to you, and welcome to the boards.