Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.40K
Please see and find out what was the problem. It's seem OK on me but it doesn't work on vb code using SQL Server 2000 [code=sql]"SELECT qry_close_month.Item_code, T_ITEM.item_name, " & _ "Sum(IIf(qry_close_month.Bulan='January',qry_close_month.Stock,0)) AS Jan, " & _ "Sum(IIf(qry_close_month.Bulan='February',qry_close_month.Stock,0)) AS Feb, " & _ "Sum(IIf(qry_close_month.Bulan='March',qry_close_month.Stock,0)) AS Mar, " & _ "Sum(IIf(qry_close_month.Bulan='April',qry_close_month.Stock,0)) … |