Creating formulas for each items

[Marco]

Hi. I'm building an application to calculate budgets. I would like to put in
my applicattion a form or someting that calculate the values for each item
based on formulas.

Imagine the item Salary. this is calculated based on a formula such as
(salary*tax*14months).

The value of the item water consumes is based on another type of formula
such like (consumes of m3 of water*cost of m3 of water/department)

How can I build a system like this?

I already have a table to store every item, but know I would like to have
this system, calculate item values based on each item formula.

Thanks in advance,
Happy new year.
Marco

 

[Jeff Boyce]

Marco

Microsoft Excel is a spreadsheet. If you need to do calculations, consider
using a spreadsheet.

Microsoft Access is a relational database. If you need to store data,
consider a database.

If you need to store data, then do calculations, store the data in Access
and export it to Excel for further analysis.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marco]

There's probably a way to do what I need.

I don't think that this is too much.

I hust don't know how to do it. But access rules.

 

[Jeff Boyce]

Marco

The "how to do it" is easy.

Create a query that grabs the data you'll want to analyze.

From the database window, highlight that query, then select File | Export
and indicate that it's to go to Excel. (you can also right-click the query
and select Export).

Regards

Jeff Boyce
Microsoft Office/Access MVP