Sum Problem, Help Needed

[Badeye]

I have a table for holidays taken as below

Payrollsite------SiteCode----Hours----Element----PE_Date----PE_Year----PE_Period
123456SH001---SH001------45-------3007-----01/02.2011----2011---------34
123456SH001---SH001------50-------3007-----03/05/2011----2011---------38
123456SH001---SH001------55-------3007-----04/06/2011----2011---------40
123456SH001---SH001------60-------3007-----15/07/2011----2011---------44

I need to sum the Hours column in a query but not having any luck. I have a userform where i can input dates and need the query to sum the hours for the inputed date range.

I'm using Access 2007 and any help working this out would be amazing.

Thanks,

Si

 

[PNGBill]

Can you post what you have tried so far ? Use the Hash Key above to post code.

If not, post your select query sql of the records you want to Sum.

 

[Badeye]

Hi,

Thanks for the reply, after i posted this i carried on trying to figure it out and eventually got it working with a DSum and setting the criteria Between 2 Dates.

Thanks again,

Si