Search results

Paul Thanks for that it is now working perfectly Cheers Rich

Thanks PBaldy I have now changed the code to this: Me.txtTotalEarnings = DSum("Price", "KatiesPeriodTakings", _ & "AppDate" >= CDate([Forms]![frmKatiesTakings]![txtStartDate]) And _ & "AppDate" <= CDate([Forms]![frmKatiesTakings]![txtEndDate])) But I am still getting a type mismatch Thanks...

Hi Hopefully someone can help. I am trying to use dsum to calculate a sum from either a table or query to display on a form and this needs to be for different services within a period so I am using the following: Me.txtTotalEarnings = DSum("Price", "KatiesPeriodTakings", "AppDate" >=...