Would someone please help me by checking my rank table in my database? Please let me know if you feel it setup properly and that the formulas work efficiently.
Database Attached
The one problem I’m having is that when the rank reaches its max number it just starts putting in the total number of records for the entire table. So say I have 750 records and all the rest have 0, it would put the total number of fields in all the 0 fields. I would like it to just match the last record with a count then add one. So if the last record was 750, all the zero’s would be 751.
Second thing I was hoping you have look at for me. Some times the rank jumped form 125-135, when if it was ranking correctly it would go from 125 to 126 and so on.
I greatly appreciate your time with helping me with this issue, and help me with a better understanding of how I can work with access in a more efficient way.
If you feel there is a better way for me to do anything in this database, please don’t hesitate to express your thoughts.
Thanks again
Corey
Database Attached
The one problem I’m having is that when the rank reaches its max number it just starts putting in the total number of records for the entire table. So say I have 750 records and all the rest have 0, it would put the total number of fields in all the 0 fields. I would like it to just match the last record with a count then add one. So if the last record was 750, all the zero’s would be 751.
Second thing I was hoping you have look at for me. Some times the rank jumped form 125-135, when if it was ranking correctly it would go from 125 to 126 and so on.
I greatly appreciate your time with helping me with this issue, and help me with a better understanding of how I can work with access in a more efficient way.
If you feel there is a better way for me to do anything in this database, please don’t hesitate to express your thoughts.
Thanks again
Corey
Comment