Result of a query into a variable in VB.NET

  • Thread starter Thread starter Tom.Lismont
  • Start date Start date
T

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?
 
Back
Top