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.

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]