Maths within a table

[battenberg]

Hi

sorry if this is a dumb request....

I have a table in which I store: 'cost price' , 'sell price' & 'Profit'

what method can I use to automatically populate the 'profit' based on the entry of 'cost' and 'sale' price???

Thanks in anticipation

 

[ColinEssex]

Assuming you're not including any overheads, tax etc etc

The gross profit is [sale price] - [cost]

No need to store the profit, calculate it when you need it (in reports for example)

Col

 

[battenberg]

Thanks Colin.

That makes perfect sense