Access formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I come from an Excel background, so I find that I am at a loss. I am trying
to build a database to code in old invoices. Different bits of information
need to be tallied and reported on.

From what I can glean from the instruction manual, I should be able to
produce these formulas through a number of different queries?

I don't understand how this works. I don't understand how to code the
formulas for Access.

Please help me wrap my head around this. I will need to calculate
quanities, price, GST, Cost per copy (cost divided by quantity).

Help!
 
It might be easier if you ask us a specific question. What data are you
storing in your tables?

For example,

Let's say you have a record in your table that includes a date, a part
number, price paid, and a quantity.

To get the extended total, you could pull those fields to a query. In a new
field in your query, you'd put something like the following in order to get
the line total or extended total:

ExtTotal: Quantity * PricePaid



To get a cost per copy (assuming you are storing the extended cost and the
quatity, you'd do a similar calculation:

CostPerCopy: TotalPrice / Quantity



If you need further help, post back.

You should think about opening the sample database that comes with Access
(Northwind) or any of the templates that ship with Access. You can play
around with those for an hour or two and pick up tons of useful hints.
 
Rick B,

Thanks for the info. I think this will help.

The fields I will be using are pretty standard: Vendor, ID#, Quantity, Date,
GST, Cost, alterations.

I would be totalling the cost, GST, Cost per copy, what percentage of the
cost was the alterations. I think your post was helpful, although if you
have anything further to add, I would surely benefit.
 
Back
Top