I have an interesting problem hopefully some bright spark might be able to solve:
I am developing automated report showing four photos per page. Each photo is numbered 1,2,3 etc. Using the page number (call this Z) it needs to work out, in order, which photos to choose out of the list.
There needs to be four seperate equations (one for each of the photo blocks) to choose the number of photo needed.
I.e. Page 1 has photos 1,2,3,4. Page 2 has photos 5,6,7,8 etc..
An example for two photos per page would be:
Top photo block calc = ((Z-1)*2)+1
Bottom photo blocl calc = Z*2
For four photo blocks however just gets a bit too much for me to work out!