Here's a real easy one for you guys 1

[Scorez2000]

I have a table called directory, and within this there is a field called AnnualBalance which is a number field. The primary key is employeeID.

I want to run a query that adds 1 to one annualbalance where the employee number is 487.


I'm doing this through ASP, so I was just going to read the value out into the ASP script with a query, assign it to a variable, add 1 to that variable and then run another query to write it back, but I'm guessing there's a quicker way.

 

[alvechurchdata]

I'm guessing there's a quicker way

Try something like:
update directory set annualbalance=annualbalance+1 where [employee number] = 487

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Scorez2000]

yep, that done the trick. Thanks.
You get a star. YAY!!!