Sorry if this is the wrong forum, cos it's SQL and VB2010
So I have my sqlserver database 3.5 compact editon called "Dive Club Records" and in it are stored columns of dive trip information and I want tthe user to be able run a query from my VB2010 application to sum a divers
total dive hours and display it on the form,
eg: MemberID, FirstName, LastName, DiveTime
by the way divetime is a real number recorded as 15.5, 20.5, 5.0 etc
What is the easiest way to do this?
Would prefere to do it from within VB2010 code if possible or make a query from the datagrid on my form using query designer.
thanks for any suggestions from you all, hope you can keep them simple for me :)
View Complete Post