Presenting forms in a certain way

[Bell]

Hi,
I'm trying to create a forms that should look in a certain way but I'm
begining to wonder whether it is possible at all.

I want to have a form that is looking as below

Account - Account Name - B0501 - F0501 - O0501 - B0502 - F0501 and so on
3010 Sales 50 50 45 60
70

Account and Account Name are the field names from the table Accounts whereas
the values that should be presented in the B0501 (equal to Budget 200501) is
a specific amount that correspond to the following primary key;
Cost Unit (e.g. 101,102 etc.) - Category (Budget, Forecast, Outcome) -
Period (e.g. 200501,200502 and so on) - Account. Hence these are the field
names in the table data with the last field Amount which is the variable
value. I'm want to use a ParaForm for the user to input desired cost unit
prior to entering the form.

Trying to create a form with the desired view I've been trying with various
queries but once I get it to look somewhat similar to above it is no longer
possible to update the values in the forms. Furhtermore my question is
whether this is possible at all and if is how one should go about doing it.

Thanks in advance / Bell

 

[Klatuu]

It may be necessary to create an unbound form, do the calculations, and
present the data using VBA.