Search results

Hi peeps, I wonder if any of you fine programmers can help me with a tricky conundrum - I have an access database which is used by several staff and which is fully functional except for one thing. The database has a function in a module which automates a simple email with reference numbers...

Hi All, I've resolved this now - I approached it slightly differently and used the following formula instead which works perfectly. =DSum("[JobSize]","CompletedMRE","Month([DateCompleted]) = " & getmonthno(Combo25.Value) & " And Year([DateCompleted]) = " & YearCombo.Value) Rob

Hello all! I've not been able to find anything in the forums to solve this specific problem, but apologies if it has already been covered. I have a form with two fields, Combo25 used to choose month (as a no between 1 and 12) and YearCombo to year (2012, 2013, etc). I have another field which...