I have a tab control with 6 tabs.

1-sheet 1

2-sheet 2

3-sheet 3

"""""

"""""

Inside each tab i have a container with a picture

so in total i can have up to 6 jpegs.

So what im trying to do is have a field populate with something like "1 of 6" depending of how many pictures i have in my tabs. So for example is the sales person put 3 Jpegs in Total (utilizing 3 tabs) i want the field to say "1 of 3" in that case everybody know how many pictures we have to a certain record. THis will help us so we don't have to look at every tab.

Any Ideas.

THanks

Hi

this can be solved with the Count ( ) function.

If those picture are stored in a repeating field of 6 repetition, the calc is very easy:

Case(

Count( repeatingField );Count( repeatingField ) & " of 6";

""

)

If those fields are 6 "normal" fields:

Case(

Count( Field1;Field2;Field3;Field4;Field5;Field6 );Count( Field1;Field2;Field3;Field4;Field5;Field6 ) & " of 6";

""

)

Thank you very much..... It worked!!

So on the same note. What can i do if i want the Page # to change everytime i go tab #2,and tab 3 and so on. for example if there are 4 jpegs out of 6 tabs, and everytime i go to tab 2 i want the number to show "2 of 4", then if i go to tab 3 i want it to show "3 of 4" I hope this makes sense. It probably would be driven by a script when i click on the tab.

Thanks