How do I put different formulas into an access database?

[Guest]

How do I put different formulas into an existing access database where I will
be continuing to add new data? Like, I need to add fields together.

 

[Rick B]

Where? In a query, report, form? You'd have to tell us what you are trying
to accomplish.

If you have two fields that you pull to a query and you want to add them
together, then you'd add a new column to your query and put something like
the following in it...

SomeNewName: [Field1] + [Field2]

For a report or a form, you'd create an unbound text field with something
like the following...

=[Field1] + [Field2]

You would not store a calculation in your table. That would be redundant
and would lead to problems if someone updated one of the fields, but forgot
to update the calculation.

 

[Lynn Trapp]

Add your formulas to a query. If you just want to get the total of values
across a row you could add a field like this to your query:

Select Field1 + Field2 As YourTotalField
From YourTable;

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html