Hi, when i select "sale ok" i am adding to the database in field  called "testing 33".
this adds fine
So please dont include that in the code.
I want to be able to do this following: I know the code is wrong but it willhelp explain what i need.
DB5.Text=('Sale ok') and the labelsales:=('test33')
form1.label1.caption := form1.adotable2.Fields.AsString; < must count
I want it so when it adss to the label it counts.. so if i add 10 sales thelabel reads 10
please dont use posex or query as i need this part simple.#
if i have to edit the sale and give a refund, i will make change the status of sale ok to something.. and update. I then want it to take away the count igave it in label 1. for example if i sell 10 and refund someone,i change status of sale ok, label needs to say sold 9