Special form

[stephanev]

Hello,

I need your help.

in a budget application I'ma making, I have a table with all the budgets names, a table with the 12 months of the year, and a table with the budget, the months and the amount allocated for every budget topic for every month.

In order to facilitate the yearly view, i would like to build a special form that shows all the budgets for every month. Each column would be a diffetent month, the fist one being filled by the budget topics (a bit like an axecl sheet).

How can I build this form?

It is very helpfull for the application because it helps the user to fill the budgets month by month, but with keeping a yearly view (instead of having a long list of 3 columns, 1 for the budgets names, one fir the monthes, and one for the amounts).

Thanks in advance for your help.

 

[supercharge]

I'm having a hard time picturing what your form would look like. Can you draw it up somehow? or explain more.

 

[stephanev]

Form sample

Supercharge, here is a drawing of what I want to build.

thx for your help.

Stephan

 

[Rich]

Using access as a spreadsheet isn't a good idea, you should normalise your data first, then you can use a crosstab query to display the data like a spreadsheet

 

[stephanev]

OK, but the crosstab querry won't allow the user to be able to fill the data....

I don't want ti use the DB as a spreadsheet. It is just that I would like this way of representing the data.

 

[Rich]

I know and it is possible to enter data in a normalised db in a spreadsheet fashion, but it requires a lot of code.
I'm sure Pat posted an example on the forum earlier this year

 

[JoeCruse]

Yes she did. Search on nonnormal or on my name, as I posted in the thread she attached the sample in. It is pretty good, and I've used it to make a form set up to enter data in a non-normal fashion. Her example looks like a spreadsheet. It takes a couple of extra queries for each attribute/column to show in the "spreadsheet", but works great.