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.
Yours works, but when I copy paste the same formula for my database I get an error. Usually it would give a warning triangle for the error (like the circular reference above) but in this case I don't get a result. I also put it in the footer, yeah it's a wip presentation wise. Is there a way I...
I've given this a shot also but the expression is invalid, I think I've matched it unless there's something I misspelled etc.
That's possible, I checked out what the error was in design view and I'm getting that it's a circular reference. I just made this database to test the report out as a...
Understood, I used the formula you provided and I still return this. Very stumped as to what is giving me error still. Is it just the case that I cannot just make a blank report, put a textbox in and have it count a field from any other table/query without doing something first?
Thanks for the response, I've pasted this in the control source but I'm still returning an error, is there any checks I should do in the formatting or fields in the table etc?
Hi All,
I'm trying to build a report that has text boxes which will count fields in a given query or table, for example I have multiple products in this table with various weights
Now I want a report which will count all the weights in that field which are >10 (which should be 2). So I've...