Click here to Skip to main content
15,915,805 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: image property Pin
Fantasca4-Jan-05 0:08
Fantasca4-Jan-05 0:08 
GeneralDatePicker default value Pin
bexarcounty3-Jan-05 12:00
bexarcounty3-Jan-05 12:00 
GeneralMouse_Hover Event Pin
azam3163-Jan-05 9:52
azam3163-Jan-05 9:52 
Questionhow to compare two images ? Pin
3-Jan-05 8:31
suss3-Jan-05 8:31 
Questionhow I read bmp's pixel? Pin
Mars9993-Jan-05 7:51
Mars9993-Jan-05 7:51 
Generalneed help Pin
RygleD3-Jan-05 6:44
RygleD3-Jan-05 6:44 
GeneralWindows Clipboard Pin
Damian Castroviejo3-Jan-05 5:55
Damian Castroviejo3-Jan-05 5:55 
GeneralAccess to T-SQL Pin
edd1em3-Jan-05 4:53
edd1em3-Jan-05 4:53 
Hi,
I am re-writing an application that used access as the backend.
I am using t-sql.
I have a query with this line, and I would just like to know the best way to convert it to sql.

CCur(Format(DSum("[Amount]","Line_Item_Payments","ChargeID=" & [Charges].[ID] & " AND Type =" & 4),"#,##0.00;;;0.00")) AS PC

Basically it looks in Line_Item_Payments for every charge in Charges and totals it by type.

I have been working with this query for a bit and have been unable to have workable results come from it.

Please help,
-Edward
GeneralMake Data Grid Up to date Pin
widhie_prihatna3-Jan-05 1:11
widhie_prihatna3-Jan-05 1:11 
GeneralSlow performance Pin
WillemM2-Jan-05 21:10
WillemM2-Jan-05 21:10 
GeneralAXMSFlexgrid1 Pin
Anonymous2-Jan-05 11:11
Anonymous2-Jan-05 11:11 
GeneralSplit array Pin
Anonymous2-Jan-05 10:46
Anonymous2-Jan-05 10:46 
GeneralRe: Split array Pin
Dave Kreskowiak2-Jan-05 12:02
mveDave Kreskowiak2-Jan-05 12:02 
QuestionHow to Learn VB without Visual Studio Pin
Ajit Jagannath1-Jan-05 22:56
Ajit Jagannath1-Jan-05 22:56 
AnswerRe: How to Learn VB without Visual Studio Pin
Dennis C. Dietrich2-Jan-05 13:56
Dennis C. Dietrich2-Jan-05 13:56 
Generalconvert to double Pin
Anonymous1-Jan-05 19:21
Anonymous1-Jan-05 19:21 
GeneralRe: convert to double Pin
Robert Rohde1-Jan-05 20:28
Robert Rohde1-Jan-05 20:28 
GeneralRe: convert to double Pin
T Manjaly5-Jan-05 5:41
T Manjaly5-Jan-05 5:41 
GeneralUse chart control in vb.net application Pin
Mekong River1-Jan-05 17:43
Mekong River1-Jan-05 17:43 
GeneralRe: Use chart control in vb.net application Pin
Robert Rohde1-Jan-05 20:35
Robert Rohde1-Jan-05 20:35 
GeneralRe: Use chart control in vb.net application Pin
Mekong River1-Jan-05 22:19
Mekong River1-Jan-05 22:19 
GeneralRe: Use chart control in vb.net application Pin
Robert Rohde2-Jan-05 3:31
Robert Rohde2-Jan-05 3:31 
GeneralRe: Use chart control in vb.net application Pin
Mekong River2-Jan-05 10:21
Mekong River2-Jan-05 10:21 
GeneralPretty Code in Forum Pin
OICU8121-Jan-05 13:49
OICU8121-Jan-05 13:49 
GeneralRe: Pretty Code in Forum Pin
Dennis C. Dietrich1-Jan-05 16:06
Dennis C. Dietrich1-Jan-05 16:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.