Thank you Rabbit - I will try to figure it out

Thank you Rabbit. Would you be able to give me some help on how I would do that in a report? I am basically teaching myself to use Access and it is not always easy to do because examples never fully apply to my database!

Any help you could give me would be very appreciated!

Kind regards

Jess

Hi

I have a query which has fields in showing how close a client is to their renewal date, or how overdue they are. I wanted to have a totals column at the bottom of the query showing what percentage of the total records had negative values in (therefore where the client is overdue) but the totals query option on tell me how many records there are in the query. How to I create a total row at the end of my query to give me the percentage...