Update Query Arithmetic

[dickey38]

My experience with database operations is minimal, so this is probably a dumb question, but:

Is there a way to update a field based on its current value with one query? Like if a table has field "quantity", incrementing that field in a particular record using a single Update Query? Something like:

Update mytable set quantity=quantity +1 where mykey = ?

I have done some web searching but found nothing along this line.

Thanks.

[burrina]

Yes. Just add your field quantity to your query grid and for your criteria use this.
Example:

Refer to the form; [Forms]![YourFormNameHere]![SomeValue]Refer to the Quantity; [SomeQuantity]+1

HTH

[dickey38]

Burrina,

Thanks for your suggestion, but I must confess I don't understand it.

Guess I should have noted that I am working with an Access Database in a website environment, working in ASP.NET. Using server-side scripting, I connect with the database using a connection string, and use methods like ExecuteNonQuery (which takes an SQL query string) to do an update. As far as I know my SQL query can only reference table names and fields in the database. Don't see where a form name comes in to play.