calculation field in half

[cjk]

I am makeing a simple solution to keep track of my dvd:s (just for practise) and now I figured I want to rate them as well. tought of displaying the rated value graphicaly as bars. Would rate them 1-5 and have a repeating calculation field displaying a box in the first repetition if the value is 1, a box in the first and second repetition if the value is 2 and so on... My problem is I do not know how to get the calculated value to display in the repeated boxes, only the first repetition seems to get any value at all. If anyone have a solution please help me.

[danjacoby]

You can create horizontal bar charts by using a calc field:

Left("|||||||||||||||||||||||||", Number * (VertLines / MaxNumber))

Where "Number" is the value assigned (in your case, 1 through 5), "VertLines" is the number of vertical lines in the calc (here I've used 25), and "MaxNumber" is the highest value allowed (in your case, 5). Then choose a bold font and color.

Note: You may want to double this field, and offset one copy by a pixel; otherwise you could get spaces between the vertical lines. Experiment, and enjoy.

Note 2: You can use variations on this to create Gantt charts (very useful for project timelines).

[cjk]

Thank you for your help! I tested the calculation and got it running the way I wanted to. Thanks again.