Can Access do some basic calculation ?

[Jayevans]

I just want it to deduct:
one numeric field from another - to get a miles travelled number ?
one currency figure from another - to get how much more/less fuel was used than last month ?

also to work out:
an average of 3 figures
to multiply one figure by another ?

Is this possible ?
How easy is it ?

This is because I want to move my Excel spreadsheets to Access so I can alalyse it better and create custom reports. But despite browsing Access for a while, I can't find the features I need, or anything in the help file to help me.

I've been using Access for a few years (Access 2000) and have created two custom databases from scratch.

Jay Evans
IT Support Co-ordinator for Simply Drinks Ltd

 

[trucktime]

Calculations

If you search the Forum you will find plenty of information about calculations
and how to implement them, as well as tips about importing spreadsheets.

 

[andrew93]

Following on from Pat's suggestions, here is a webpage on database normalisation, and a couple of pages on calculations in queries here and here.
HTH, Andrew