Sorry for the waste of time guys just saw my formula had this for some reason:
=DCount("Weight","tblNumbers","Weight > 10")
which as you can see doesn't match the "Weights" tblNumbers, the minute I replaced it everything was sorted.
Many thanks for your patience with helping me out.