Guest lavida01 Posted November 5, 2008 Share Posted November 5, 2008 Good Day AllI have a table (access 2000) like this :iddate&timeamount1amount2amount3I want to display using asp the total of each amount for each day, means :If I have this : Date amount1 amount2 amount315/10/2008 12:30 10 10 1015/10/2008 15:50 10 10 1016/10/2008 11:20 25 25 2516/10/2008 15:11 13 13 1316/10/2008 14:00 5 5 525/10/2008 10:00 3 3 3I expect to display this:Date amount1 amount2 amount315/10/2008 20 20 2016/10/2008 43 43 4325/10/2008 3 3 3I tried many queries but they all turn some errors.Many thanks in advance.Moony Link to comment Share on other sites More sharing options...
amj Posted November 6, 2008 Share Posted November 6, 2008 Can you give us an idea of what code you have entered and what SQL statement you ar using to access view the data? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.