Rick, on a tangent - almost!,
I can sympathise on why Steve wants to do something like this, and I am
interested to see if it can be done.

Each month I have to tally up the mileage and fuel purchased for a
substantial fleet of vehicles, and have to do it from hand-written sheets.
At the moment I use Access to calculate the start and end mileage difference
(naturally), and then have to use Calc.exe to total the number of litres
used for those miles/kilometres (which can be many entries). This means
'alt-tabbing' between Calc and Access. If the ability to use the Calc.exe
was available, or something similar on the same screen, it would certainly
make my life a lot easier!

Perhaps you can suggest some code to add up the multiple fuel purchases and
place it in the 'fuel_used' field?

TIA

DubboPete

"Rick Brandt" wrote in message
...
"Steve Fama" wrote in message
...
How do I store calulations in a table. I have calc. in a
form, how do I store the results in a table. Please help

In almost all cases you DON'T. If they can be calculated they don't need
to be
stored and it is bad design to do so. Can you explain why you want to?


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com