Is it possible to + x - and so on in Access

B

Bocker

Previusly I have worked with Lotus Approch - There it is possible to do a
littel bit like in a spread sheet.

Lets say I want to make a small application, where I bill a customer for to
different products - I want to be able to make a line for each product and to
put in how many peaces - this should then give me the total for each line,
and a total for every thing on the to lines. Then I want to ad tax etc.

Can this be done or do I have to continue with Lotus Approch ?

Sincerely
Jesper
 
P

Pat Hartman

Yes it can be done but probably not the same way you are doing it in
Approach. Access is a relational database and so good practice would
dictate calculating totals rather than storing them. To have an extended
total for each line item, add an expression to the query to calculate it.
Select ItemID, Quantity, UnitPrice, Quantity * UnitPrice AS ExtendedPrice
From yourtable;

Store the tax rate in a lookup table. and add it to the Order Header when
the order is created:

Me.TaxRate = DLookup("TaxRate","tblTax","EffectiveDate <= Date() AND
ExpirationDate >= Date()")

In your report, you can create the final total and show the tax etc.
 
J

John W. Vinson

Previusly I have worked with Lotus Approch - There it is possible to do a
littel bit like in a spread sheet.

Lets say I want to make a small application, where I bill a customer for to
different products - I want to be able to make a line for each product and to
put in how many peaces - this should then give me the total for each line,
and a total for every thing on the to lines. Then I want to ad tax etc.

Can this be done or do I have to continue with Lotus Approch ?
Click to expand...

This can certainly be done, using an Access Report's Sorting and Grouping
feature and queries.

If you're expecting to do it in exactly the same way as you're used to doing
in Approach, you'll be disappointed. Access is its own program, not a flawed
implementation of Appoach; you'll need to step back a bit from "how this is
always done" and learn a new approach. <sorry>

John W. Vinson [MVP]
 
Top