I have what will, I'm sure, turn out to be a very simple calculation but I'm drawing a blank... Too many years since High School I think
What I have is a table that maintains positions and these positions are stacked, with each successive row containing twice as many positions as the previous row.
What I need to be able to determine based on record number, starting with 1 and incrementing with each new record...
If I am inserting what will be record number 3450, which row will it be on, and what relative position within that row will it hold.
The math will actually be easy to determine the relative position after determining the row number, but I'm blank on the formula to determine the row.
Any help out there this late at night??
Thanks in advance