demogorgan
Registered User.
- Local time
- Today, 16:46
- Joined
- Nov 29, 2017
- Messages
- 37
Hi,
So I am using DCount on a unbound txt box to total results from a query using criteria based on a number of days. I.E count all records with "1".
The query is displaying the correct number of results for "1", in this case 14 - however the DCount is displaying 13. I have also tried this on other counts I.E "2" etc, again the query displays different counts than DCount ?
This is what I am using
Any ideas ?
Thanks in advance
Demo
So I am using DCount on a unbound txt box to total results from a query using criteria based on a number of days. I.E count all records with "1".
The query is displaying the correct number of results for "1", in this case 14 - however the DCount is displaying 13. I have also tried this on other counts I.E "2" etc, again the query displays different counts than DCount ?
This is what I am using
Code:
=DCount("[CreateVrequ]","qryCrtVsConEx","[CreateVrequ]= '1'")
Any ideas ?
Thanks in advance
Demo