Divide and store

[staines]

Hi hope someone can help,

What I’m trying to do is work out price per quantity, at the mo I have a database that has products and price so lets take paint for an example.

If I have a 5 litre pot of paint and I’m selling it for £10 I would like a field that tells me the price per litre, so what I’m think I need to do is have a field called ”price” and divide it by a second field called “quantity” and output the sum to a third field called “price per litre” which populates the database.

Sadly I haven’t got a clue how to do this with access and if anyone can help it would be much appreciated.

Thanks

 

[Mile-O]

Do the calculation in a query or a form. You do not store the result of a calculation in a table - it goes against the rules of database design.

On a form:

=[Price]/[Quantity]

In a query:

PricePerLitre: [Price] / [Quantity]