Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-24 : 07:42:24
|
| tonytom writes "I am using access database in vb6 i want to put a sql intruction to sort by item between date1 and date2 group by itemand add a sum(quantity) in the report can't someone helpme, I was 3 days trying and my mind is geting burn.." |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 06:54:32
|
| [code]SELECT Item, SUM(Quantity)FROM YourTableWHERE SomeDateColumn BETWEEN @date1 AND @date2GROUP BY ItemORDER BY Item[/code]Peter LarssonHelsingborg, Sweden |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
need help in a report 