Having acces compute a formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: chang (222_at_eee.com)
Date: 07/22/04


Date: Thu, 22 Jul 2004 19:54:18 GMT

I want it that i will have a form to enter information, i will choose from
a drop down a list a customer name (which all of his info gets enterd into
from another form). i will then coose a "pipe style" (i will have set the
ratio of weight per foot using a different form) the I want to be able to
enter the Metric weight of the sale and also enter the total price that i
am paying for it and the total price that i am selling it for. I then want
it to calculate the weight in "Short tons" (it is a simple mutiplication
formula) . I also what it to display the price per foot (for both me and
the customer) based on the ratio that is for that pipe style. and I nead it
to save the information.

I know how to do the basics, but how to set it up to deal with the formulas
and to save information is what i nead help with.



Relevant Pages

  • Re: Having acces compute a formula
    ... If you're creating invoices or the like you can create Report ... so I recommend that you invest in some books. ... > ratio of weight per foot using a different form) the I want to be able to ... > am paying for it and the total price that i am selling it for. ...
    (microsoft.public.access.gettingstarted)
  • Re: Supermarkets and price per kilo
    ... It is customary when selling pre packaged to mark the weight of the ... customer can select the one she thinks is the heaviest. ... it must be for a metric quantity, ...
    (uk.legal)
  • Re: Supermarkets and price per kilo
    ... It is customary when selling pre packaged to mark the weight of the ... customer can select the one she thinks is the heaviest. ... it must be for a metric quantity, ...
    (uk.legal)
  • Re: Supermarkets and price per kilo
    ... It is customary when selling pre packaged to mark the weight of the ... customer can select the one she thinks is the heaviest. ... it must be for a metric quantity, ...
    (uk.legal)
  • Re: Excel, Access, or Something Else?
    ... Sounds like one thing you need is an incrementing ticket number. ... > a full truck of metal and then enter the empty weight of the truck. ... > T589 to start with for the next customer and name it T590. ... > would not be stored on the template because the name was entered and saved ...
    (microsoft.public.excel)