access help on query

[Steven Low]

hi guys

im creating a table with 3 colums which are reader avaiable and used

what i like is in the avilable colume there would be 10

and in the used colum if i type 1 it would lower the avilable colume.

so something like

avilable col
-------- ----
9 ...........1


but i am not sure what kind of a query i would need for this type of problem and need help guys.

 

[cjard]

UPDATE table SET available = available - 1, used = used +1 WHERE available > 0