i'm simply trying to add each numeric record in a particular colum to get me the total. e.g. User selects # of guest and I can get a total of all the users guest. Thanks
select sum(NoGuests) from tablename.<BR><BR>NoGuests would be the appripriate column name.<BR><BR>I am not sure if you wanted this.