Result of a query into a variable in VB.NET

[Tom.Lismont]

Hi there,

I'm currently working on a small project to create an overtime hour
app. I'm a little bit stuck on the part where I want to make the sum of

all the overtime hours entered in my db.
I'm working with an Access db. Users can enter the amount of overtime
hours performed on a single day. Every day is 1 record. What I want to
do now is make the sum of all the hours that were entered and pass it
into a variable. I can create the query with a SELECT SUM (...) but I
don't know how to pass the result back into a variable in VB. I need to
have it in a variable in VB because I need to do some calculations with
it.
Could somebody help me out with this one?

[Ken Tucker [MVP]]

Hi,

Take a look at oledbcommand.executescalar
http://msdn2.microsoft.com/en-us/lib...utescalar.aspx

Ken
--------------------
<To*********@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...

Hi there,

I'm currently working on a small project to create an overtime hour
app. I'm a little bit stuck on the part where I want to make the sum of

all the overtime hours entered in my db.
I'm working with an Access db. Users can enter the amount of overtime
hours performed on a single day. Every day is 1 record. What I want to
do now is make the sum of all the hours that were entered and pass it
into a variable. I can create the query with a SELECT SUM (...) but I
don't know how to pass the result back into a variable in VB. I need to
have it in a variable in VB because I need to do some calculations with
it.
Could somebody help me out with this one?

[Tom.Lismont]

Thnx , This is what I was looking for.