Incrementing the value of a field

[shauns1]

Hi

I have a table of PDF Files that can be downloaded from the server. I have a field named downloads that will store the number of times the file is downloaded.

At the moment, I retreive the value of downloads, increment it within my web page and insert the new value back into the database.

Is there a way I can increment the value within one sql statement? I'm using Access.

Many thanks

Shaun

 

[PHV]

UPDATE tblName SET increment=increment+1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shauns1]

Perfect! Cheers me dears!