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

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

Thanks Colin.

That makes perfect sense