...

View Full Version : code to total a number value?



startbar
09-01-2004, 12:12 PM
hi, if i have a field on an access database what code can i use to total all of the entries of that one fields.. i.e total number of tickets sold : #

thanks

shmoove
09-01-2004, 01:03 PM
select sum(the_field) from the_table

Assuming that the_field is a numeric field of course.

shmoove



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum