matrixbox?

[adiazram]

Hi! Can anyone tell me how to do this: i need to do a product sales budget with a form like this: …|…january…february No…Desc.|.qty…$…amount|…qty…$…amount art1…art1…|.20…100…2000… .15…100…1500 art2…art2…|.10…150…1500… .15…10…150 (The … only for presentation) where the rigth rows are introduced by user. and the time periods can be changed to days, months, etc. comments or suggestions? Thanks

[quote]

[fabian]

You need to use Integer rather than date as table for the columns. 1 would stand for January-qty, 2 for january-$ 3 for january-amount and so on. (Number Div 3) + 1 indicates the month (Number Mod 3) would indicate qty, $ or amount. Not very trivial but interesting. With best regards from Switzerland Marcus Fabian