Access - Budget database

[fanzak]

Hi Everyone,
I am newbie to Access databases and I was asked to build a database that would present the current budget of the company. However, I have faces a bit of problems while designing it.

The problem is, that I am supposed to create a database that reflects the excel file - design either. In result I have lets say such a table in excel:

----------------------Jan-----------------------Feb
Gas usage [m3]--------1-------------------------1
Gas Price [$-----------2-------------------------2
Water usage [m3]------1-------------------------1
Water Price [$]---------2-------------------------2
-------------------------------------------------------
Total Gas =Gas-usage * Gas-price =Gas-usage * Gas-price
Total Water =Water-usage*Water-price =Water-usage*Water-price

I am aware of the fact, that i will not keep the totals in the table but in the form/report.

However, how can i ask access to multiply just specified records? I presume, Gas usage, Gas price etc will be the records in the table. The problem is outcome of the access report, must look the same as the Excel Spreadsheet. So if Gas usage is first, it must be on the first position and so on.

Thanks for your time and concern!

[dsmacs]

Hi,

You should have an accounts table which will include the Account Number the account name and include a sort order field.

You will also need to include a Price table for the different prices for each account and the date range the price applies to

A table for the Usage include the date and the account number

If you need further assistance attach sample of the desired excel layout.

Regards
Darren